I would like to use [MonetDB](https://www.monetdb.org) in production as our use
case is heavily depending on mysql / mariadb just because it's MyISAM tables
are so fast. PostgreSQL and a lot of other DBs I tried faint already on
importing the data and are magnitudes slower in querying them. But
Will I get in trouble for saying:
**_MySQL sucks, use PostgreSQL_** :P
Well, the fields of the table are not the same as the fields of the result of a
query!
AFAIK the "higher level" wrapper can't do what you want.
I once played around with it and wrote something like this:
import strutils, os
# NOTE: Some versions of the nim library have the
`instantRows` iterator calls `setColumnInfo()`
so (untested code :) ) where `theDb` is your dbConn object and `myTestTbl` is
the table being queried, and using count(*) to return only one result so that
the column representation is not printed for multiple rows
var dbC: DbColumns
Instead of returning just the row/s is there a way to return
column_name:column_value pairs?