[Feature Request] Need a proc to trigger barebone SQL commands

[baalajimaestro]

I would like to create indexes on my table, and it doesnt look like possible with norm. I just need a proc like dbConn.exec which supposedly does handle any sql query on postgres, but doesnt work on sqlite for some reason.

[moigagoo]

DbConn is a type Norm borrows from ndb. It offers exec proc for both SQLite and Postgres:

• https://xzfc.github.io/ndb.nim/v0.19.8/sqlite.html#exec%2CDbConn%2CSqlQuery%2Cvarargs%5BDbValue%2CdbValue%5D
• https://xzfc.github.io/ndb.nim/v0.19.8/postgres.html#exec%2CDbConn%2CSqlQuery%2Cvarargs%5BDbValue%2CdbValue%5D

What problem specifically are you experiencing?

[PhilippMDoerner]

I think currently the task of adding an index to a table would be done via using the sql con provided by norm.
It does pose an interesting idea though:
Should creating an index be done via raw SQL or should norm provide a way of facilitating this, e.g. by having an "index"-pragma ?

[moigagoo]

Should creating an index be done via raw SQL or should norm provide a way of facilitating this, e.g. by having an "index"-pragma ?

I think having a pragma for it would be great. The code would be very literal, which I like.

[PhilippMDoerner]

I think having a pragma for it would be great. The code would be very literal, which I like.

It wouldn't even be that much more work, would it?

Like, basically that just means extended createTables.
Have an index pragma that you can associate a string with, like with tableName but now for indexName.
Iterate over all fields on a model object, check if the field has an index pragma.
If it does, get the index name and add it (associated with the column name) to a Table[string, seq[string]] that associates index-names with a seq of column names that have an index-pragma with that particular index-name.
Once one has iterated over all fields, you can iterate over the index-names in that table and generate an SQL statement for each.

If we want to make sure a column can be in multiple indices, we could even make it so that the String is a comma separated list of index-names and during processing we just split by comma, strip the ends of whitespaces and then add the individual fields to the table.

I think that might be it already.
Am I missing something?