Hello ! I'm writing an application that uses the column declared/type to do some formatting, it's working fine for tables and most views except when the column is calculated like:
SELECT id, name, (weight / height) AS pseudo_mass? FROM people; I can get the column type of "id" and "name" but for "pseudo_mass" I get nothing, even when I use "cast((weight / height) AS real)" still nothing is returned. Could be a way to set/cast the column type to be returned by sqlite3_column_type/sqlite3_column_decltype ? Recently sqlite3 add new functions sqlite3_result_subtype/sqlite3_value_subtype to do a kind of user define anottation to a sqlite3_value, could we have something like this at "sql" level ? Cheers !
