Ability to use table-specific queries

[lundibundi]

It would be great to be able to use table specific queries like
db.city.insert(...), db.account.update() and such.
Since the msql becomes aware of schemas it should be possible to implement such a utility.

IMO It will allow to make queries more streamlined and clear.

[tshemsedinov]

Here we have problem with typings, because we do not know all table names and may generate this typings from schemas in certain application.

[lundibundi]

Couldn't we generate those based on scehmas just like we generate the sql for schemas?

Alsother (much simpler) option would be to just write:

interface CollectionDB {
   insert(...);
   update(...);
   delete(...);
   ...
}

type DB = {
   insert(table: string, ...);
   update(table: string, ...);
   delete(table: string, ...);
} & { [key: string]: CollectionDB  }

https://www.typescriptlang.org/play?#code/JYOwLgpgTgZghgYwgAgMIHsA2mILMdEAEQCFkBvAKGRtAGdowAKANzkwC5k4QBPASi4AFKOgC2wBgB4evAHwBuajQCuABwAmcSEw0RMYOFwBKudFA1S6YKKADmAGm585TgHQeEhDcHyE6XACCUFBwvFKmXhZWNvZOsnJygsgi4pIQMi5KNMh6ODoebl4gPn4gAcjBoeGR5pbWtiCOzvJJwqIS0gnZNAD0vciFlAC+lJRgvGoopMgAvBTKyPSMTIYARjhcDXHIbJwtyamdGd2L6lo665vI201OeYYmZtG3zQnunt6+BOVBIWERZ71WJ3FqJQ4ddKZeQ9XL6CCXOAbCBbEHNQrFUo-CpVAG1F5o+IuNopSFdLIjZAAMgoyAA2gBrCC8VGNOwAXS4GGwuDKM2Qo0oxWsuXEcFAXBm83Iw24dGQpCUlA0YtAbjyCIgTAA5KhfLxtU5yMgQHAxCjkNqAKwAZm1Av4ShVYnFIDceom6vhOmNpvNXGtdodQA