Function compileBasicExpression

packages/electric-db-collection/src/sql-compiler.ts:101–123

* Compiles the expression to a SQL string and mutates the params array with the values. * @param exp - The expression to compile * @param params - The params array * @param encodeColumnName - Optional function to encode column names (e.g., camelCase to snake_case) * @returns The compiled SQL str

(
  exp: IR.BasicExpression<unknown>,
  params: Array<unknown>,
  encodeColumnName?: ColumnEncoder,
)

 * @returns The compiled SQL string
 */
function compileBasicExpression(
  exp: IR.BasicExpression<unknown>,
  params: Array<unknown>,
  encodeColumnName?: ColumnEncoder,
): string {
  switch (exp.type) {
    case `val`:
      params.push(exp.value)
      return `$${params.length}`
    case `ref`:
      // TODO: doesn't yet support JSON(B) values which could be accessed with nested props
      if (exp.path.length !== 1) {
        throw new Error(
          `Compiler can't handle nested properties: ${exp.path.join(`.`)}`,
        )
      }
      return quoteIdentifier(exp.path[0]!, encodeColumnName)
    case `func`:
      return compileFunction(exp, params, encodeColumnName)
    default:
      throw new Error(`Unknown expression type`)
  }
}

function compileOrderBy(
  orderBy: IR.OrderBy,