Type safety problem of Knex query builder

• Knex

  95 18,741 7.9 JavaScript

  A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

  

Knex's TypeScript support is very weak. Type inference gets disabled in rather complex queries - even in simple joins. I want to have a strong type safety for response objects of my queries. My project size is "small-to-mid". Possible solutions in my mind:

• kysely

  42 4,444 9.5 TypeScript

  Discontinued A type-safe typescript SQL query builder [Moved to: https://github.com/kysely-org/kysely] (by koskimas)

  

If you like knex checkout kysely. It's basically knex built on typescript https://github.com/koskimas/kysely

• SurveyJS

  surveyjs.io sponsored

  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.

  

• pgtyped

  34 2,800 8.7 TypeScript

  pgTyped - Typesafe SQL in TypeScript

If you would like to use raw SQL, pgtyped looks rather interesting although it only supports postgres. https://github.com/adelsz/pgtyped

Suggest a related project