prorm API Reference
    Preparing search index...

    Enumeration SqlDialect

    Every SQL dialect prorm can target.

    The value decides which Dialect implementation compiles a FindOptions into SQL, so it governs identifier quoting, pagination syntax, and which clauses are legal. Spelling it wrong is the one configuration mistake that fails at connect time rather than at compile time — 'postgressql' is a perfectly good string — which is why this is worth naming.

    new Prorm({ dialect: SqlDialect.Postgres, ... })   // preferred
    new Prorm({ dialect: 'postgres', ... })            // still fine
    Index
    Postgres MySQL MariaDB SQLite MSSQL Oracle Db2 HANA Firebird CockroachDB YugabyteDB TimescaleDB Greenplum Redshift TiDB SingleStore Turso ClickHouse DuckDB Snowflake Vertica Exasol Databricks Trino CrateDB QuestDB Spanner
    Postgres: "postgres"

    PostgreSQL.

    MySQL: "mysql"

    MySQL.

    MariaDB: "mariadb"

    MariaDB.

    SQLite: "sqlite"

    SQLite, embedded.

    MSSQL: "mssql"

    Microsoft SQL Server.

    Oracle: "oracle"

    Oracle Database.

    Db2: "db2"

    IBM Db2.

    HANA: "hana"

    SAP HANA.

    Firebird: "firebird"

    Firebird.

    CockroachDB: "cockroachdb"

    CockroachDB — PostgreSQL wire protocol, distributed.

    YugabyteDB: "yugabytedb"

    YugabyteDB — PostgreSQL-compatible, distributed.

    TimescaleDB: "timescaledb"

    TimescaleDB — PostgreSQL with hypertables.

    Greenplum: "greenplum"

    Greenplum — PostgreSQL-derived, analytic.

    Redshift: "redshift"

    Amazon Redshift — PostgreSQL-derived, columnar.

    TiDB: "tidb"

    TiDB — MySQL protocol, distributed.

    SingleStore: "singlestore"

    SingleStore — MySQL protocol, in-memory.

    Turso: "turso"

    Turso / libSQL — SQLite over the network.

    ClickHouse: "clickhouse"

    ClickHouse.

    DuckDB: "duckdb"

    DuckDB, embedded and columnar.

    Snowflake: "snowflake"

    Snowflake.

    Vertica: "vertica"

    Vertica.

    Exasol: "exasol"

    Exasol.

    Databricks: "databricks"

    Databricks SQL.

    Trino: "trino"

    Trino — a query engine over other stores.

    CrateDB: "cratedb"

    CrateDB.

    QuestDB: "questdb"

    QuestDB — time series.

    Spanner: "spanner"

    Google Cloud Spanner.

    Settings
    Member Visibility

    On This Page
    Enumeration Members