kysely-codegen

Hello HN! I was recently introduced to Kysely (https://github.com/kysely-org/kysely), a type-safe Typescript SQL query builder, and instantly fell in love! I got inspired and wanted to make something similar for AWS DynamoDB. Thus, I developed Tsynamo! Instead of calling it type-safe, I decided to go with type-friendly, because the library is still in an early stage, and is not 100% type-safe. Under the hood, Tsynamo compiles the built queries into AWS SDK v3 commands. I feel that Tsynamo simplifies the AWS SDK API quite a lot since the developer doesn't have to mess around with condition/filter expressions or attribute names/values themselves, and as a bonus gets autocompletion for building the queries! There's also a playground to test it out in your browser: https://try.tsynamo.dev. It might not have the most up-to-date API of the lib

The main difference to me is that with Prisma I don't need to do any SQL to get a project up and running. I can define the tables and relations from my code or from Prisma Studio, and in one swoop I get the db structure done and the types defined. I know my way around a database, but I'd rather not leave my code editor whenever I need to add a new column to a table. With Kysely you have to create the DB schema, and then write the types; with every change you need, you gotta do both again. (At least this seems true by default; as the project's readme mentions, there is a code generator[1] to generate the types from the DB schema; not quite the same but at least it's better than nothing.) Commenters say that writing complex queries with Kysely is easier, which makes me wonder if I could use Prisma except for those, since Kysely should be ab

I think https://github.com/RobinBlomberg/kysely-codegen does roughly the same thing?

I haven't used them, but https://github.com/koskimas/kysely and https://github.com/RobinBlomberg/kysely-codegen are doing some interesting things with TypeScript, focusing just on generating SQL queries, quite a bit more lightweight than Prisma.