tursodatabase / libsql

libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
https://turso.tech/libsql
MIT License
9.55k stars 252 forks source link

[C Bindings] Missing get declared type API on rows #1413

Open ospfranco opened 4 months ago

ospfranco commented 4 months ago

When iterating through a result set in sqlite3 the rows might return null values but the declared/infered type might be different, to get the type of the column sqlite3 offers sqlite3_column_decltype:

CleanShot 2024-05-24 at 11 05 27@2x

When using libsql there is no such API to retrieve this declared type, again this is useful to get rid of ambivalence when retrieving data from the db, it is only possible to get the type of a specific row but as stated this can be NULL depending on the queried row.

CleanShot 2024-05-24 at 11 05 19@2x

Related to https://github.com/tursodatabase/libsql/issues/1412