_sql Endpoint issues

[megastef]

1. For ORM implementation "insert into" should return generated key
2. Option to give types back. Example: a sql console can not format date, because it is not aware about timestamp columns - same functions is required for a JDBC driver (resultset meta data)

[mfussenegger]

1. So far we don't provide an option for auto generated keys. That's why there is no option to return them with insert into. If we do add that functionality it will probably in the form of the RETURNING clause. (And yes I am aware that internally we do have a unique key that is generated, but currently that key isn't really exposed to the outside)
   For ORMs our suggestion for the time being is to generate the keys on the client side.

Yep we should have types in the response pretty soon as that's one area we're currently working on.

[mfussenegger]

Hi Stefan,

with the 0.38 testing release it is now possible to include the types in the response
see

crate/docs/sql/rest.txt

Line 77 in 9796dbc

Column Types

You can download the tarball from: https://cdn.crate.io/downloads/releases/crate-0.38.0.tar.gz

[megastef]

Thx. Adapted node-crate and conZole - now the date is displayed: