First, I would not use `array[N, T]` for C interop but `ptr UncheckedArray[T]`
instead.
Usually database query returns a `string` or a `seq[string]` (when multiple
values); a `string` in Nim a `string` can be used as a buffer and then it's up
to the user to convert the result.
See [db_sqlite g
The [DuckDB C Query API](https://duckdb.org/docs/api/c/query) has two ways to
extract values from a query result. One way is to use the duckdb_value_TYPE
functions which take a row and col and return a value, the other, more
dangerous, way is to use the duckdb_column_data function which returns
