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 getValue proc](https://nim-lang.org/docs/db_sqlite.html#getValue%2CDbConn%2CSqlQuery%2Cvarargs%5Bstring%2C%5D) for example.
