Array column type
Support array column type of string, integer, decimal, object, link type. Provide standard array management operations such as pop and push. Provide aggregation capabilities on the array content such as: aggregations (sum, avg, min, max, count, unique count) filters (gt,lt, eq) sorting (asc,desc)
Implement createdAt / updatedAt fields
Mostly in databases, you want to have a created date and an updated date stored. It would make it very easy if you could create a column, assign it to the type "Date" and for the default value, say "created at" or "updated at".
Support for Image type
A rich data type that can store images natively would have been useful for us in a number of internal projects.
Export records to file
Provide the capability to easily (with no client side work) export all schema and records from a database:branch (down to per-table basis) into raw text files in JSON or CSV format
Hooks and Triggers
Provide support for hooks to act on events before and after a CRUD operation against a record. Use cases: custom validation rules, orchestration of internal or external events upon record updates.
UI import schema from json
Similar to the CLI's capability (xata init --schema filename.json, xata schema edit --source, xata schema upload schema.json) for creating or updating a database from an existing schema file, provide the option in the web UI to import schema from json in order to initiate or update a database/branch.