Add more flexibility for data types

[variety01]

Currently i can not build complex schemas with different denormalizations. Now it is strictly relational. So i suggest you to add custom data types and lists/maps.

[huyphung1602]

Hi there,

Thank you for sharing your issue with us.

Can you give us some example of your use-case and which data type list/maps that you want support?

Best regards,
Huy Phung

[variety01]

Lists and maps are necessary for non-relational databases.
A simple example of denormalization in relational is to create a list of any type in A to avoid joins. It works well if this list won't be large and is primarily used for read queries. An example could be a "books" table with field "authors" as list of strings .

Also, using JSON schema definitions is a good idea. We can store different JSONs in the "events" table but with clearly defined possible schemas. For example: "type EventCreated," "type EventCanceled," and a table "events" with a "event_data" field of "json[EventCreated, EventCanceled]" type.