Iskra API Reference
    Preparing search index...

    Function compileNamed

    • Compiles a statement with binds by name to one with binds by position, as bindStyle: 'positional' does: Oracle then never sees a bind name, so params the SQL does not use, names that are reserved words (:date, :user) and names in another case cannot fail it.

      compileNamed('SELECT * FROM t WHERE id IN (:ids) AND owner = :owner', { ids: [1, 2], owner: 'ana', extra: 1 });
      // { sql: 'SELECT * FROM t WHERE id IN (:1, :2) AND owner = :3', binds: [1, 2, 'ana'], names: [...] }

      Parameters

      • sql: string
      • params: Readonly<Record<string, unknown>>
      • dialect: BindDialect = 'oracle'

      Returns CompiledSql