Project status? about ts-typed-sql HOT 3 OPEN

I would like to point out that this project is possibly the best typed SQL builder attempt for JS/TS.

Even when compared to mature competition in other languages, the qualities of TypeScript makes the type-safe SQL builder attractive to attempt, because SQL just like TypeScript is structurally typed.

I'd like to note that this library has similar qualities as https://github.com/gcanti/io-ts when it comes to defining the underlying types. But I'm not sure can it be used for defining schema, it probably doesn't have enough info to do that.

from ts-typed-sql.

Hi Paul,
right now I have too many other projects before I can give this library the love it needs. I currently don't work on a project involving SQL.
The implementation is pretty production ready and used in a somewhat large project. I would consider the API to be stable, maybe it's a good idea to publish it as 1.0.
Afaik there are some typescript issues due to type glitches in tsc. If you are interested in using and helping to improve this library I could have a look at it.

There are some features missing:

• A concept of types with deserialization logic
• SQL Schema Generation
• migrations
• Better null handling

TypeScripts typesystem also evolved a lot during the last two years, maybe even more things could be typed. E.g. I was never able to properly handle the types of left joined columns, which could be null.

from ts-typed-sql.

Thanks @hediet for that summary, and your work on ts-typed-sql!

from ts-typed-sql.