Show HN: Kysely, a type-safe SQL query builder for TypeScript

• kysely

  26 9,317 9.2 TypeScript

  A type-safe typescript SQL query builder

  

• ts-sql-query

  2 261 9.0 TypeScript

  Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.

We moved away from zapatos because the generated types are good only when selecting from single table. The moment we start selecting some subset of columns from a join of multiple tables, it is upto the developer to provide the right combination of pick and intersection of generated types and type safety takes a hit.

The solution we use right now is ts-sql-query which supports automatic type-safety for complex joins, CTEs, subselects etc.

https://ts-sql-query.readthedocs.io/

• SurveyJS

  surveyjs.io featured

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

• prisma-kysely

  3 801 6.2 TypeScript

  🪄 Generate Kysely types directly from your Prisma schema!

I typed up a comment saying how much I’d love to drop this in alongside my Prisma code so I can keep using the ORM for simple things and have the option to drop into SQL as needed. It ended asking if anyone knew whether such a thing was possible. I decided to check the docs one more time and… here it is! https://github.com/valtyr/prisma-kysely

I’m excited. I enjoy Prisma but SQL can be expressive. Looking forward to trying this.

• drizzle-orm

  48 19,921 9.7 TypeScript

  Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

  

Another "almost" like SQL library that I've heard floating around:

https://github.com/drizzle-team/drizzle-orm

• awesome-kysely

  1 106 7.5

  A curated list of Kysely resources, tools, utilities and applications.

  

Huge shoutout to our community, bloggers and youtubers!

https://github.com/kysely-org/awesome-kysely

• squashql

  3 42 9.3 Java

  Official repository of SquashQL, the SQL query engine for multi-dimensional and hierarchical analysis that empowers your SQL database

  

I am building squashql-js for a slightly different use case (database agnostic SQL-like Typescript query builder among others) but Kysely and pypika (for Python) have been a great source of inspiration.

https://github.com/squashql/squashql/blob/main/documentation...

• kysely-postgres-js

  1 48 7.8 TypeScript

  Kysely dialect for PostgreSQL using the Postgres.js client.

  

postgres.js is dope! I'm maintaining a Kysely community dialect for it. https://github.com/igalklebanov/kysely-postgres-js

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project