PartiQL map Type Specification

[am357]

PartiQL 2019 Specification does not define a first-class map type.

Why not using struct (or tuple) Type?

It is a fair question and we need to examine it through the work required for this issue. Having said that, PartiQL struct can be used in a way as map or multimap with the limitation of their key to be string. Is that sufficient for a map type in PartiQL? considering the prior art in industry—e.g., Apache Iceberg or Hive DDL—perhaps not.

DoD

1. We have a clear understanding of why we cannot use struct (or tuple type) and need a first class type for map.
2. If we actually require map type:

• We have an experimental implementation of map type.
• We have an RFC that describes the syntax and semantics of map type.