Naming from key/value layer visible in sql #2056
Description
What would you like to be added or enhanced
The naming convention in the underlying key/value layer is visible in SQL. When querying the tables the underlying table.column value is returned instead of the actual column name. If an alias is supplied with the as keyword, this alias is allowed, but ignored.
defaultdb=> select customer_name as name, email as email from customers;
(customers.name) | (customers.email)
------------------+-------------------------
Asa Antrum | [email protected]
Neila Rowena | [email protected]
Rex Massinger | [email protected]
Whit Shilton | [email protected]
(4 rows)Why is this needed
Being able to have proper column names, and alias them with as is a core sql feature and would be an important addition for general postgres compatibility. This would also be a quality of life improvement for developers who currently receive column names in an awkward (customers.name) format.
Additional context
Immudb 1.9.6