Show HN: SchemQl light TS library for SQL with type safety and schema validation

1 point

2 years ago

SchemQl is a lightweight TypeScript library that enhances your SQL workflow by combining raw SQL with targeted type safety and schema validation. It simplifies SQL usage in TypeScript by offering two main features:

    - Robust Query Validation: Ensures the integrity of your query parameters and results through powerful schema validation, reducing runtime errors and data inconsistencies.
    - Selective SQL Typing: Leverages TypeScript to provide real-time autocomplete and validation for specific parts of your SQL queries, targeting literal string parameters for tables, columns, parameters, and selections.

SchemQl is designed to complement your existing SQL practices, not replace them. It allows you to write raw SQL while benefiting from enhanced safety for specific query elements. Key characteristics include:

    - Database Agnostic: Works with any database management system (DBMS) that has a compatible JavaScript/TypeScript client library, allowing you to fully leverage your database-specific features.
    - SQL-First approach: Provides the freedom to write complex SQL queries while offering targeted type safety for literal string parameters.
    - Lightweight: Focused on core features and intends to remain so.
    - Targeted Type Safety: Offers TypeScript support for enhanced developer experience with literal string parameters, balancing flexibility and safety.

SchemQl is ideal for developers who appreciate the power of raw SQL but want added security and convenience through schema validation and targeted TypeScript integration for specific query elements.

Zod inside. An alternative to Kysely, Drizzle & co.

WDYT?