Function coalesce

Create COALESCE expression.

import { createBuilder, coalesce, json_array_aggregate, json_object } from 'coral-sql'

const [sql, bindings] = createBuilder()
  .from('order', 'o')
  .column(
    coalesce(
      json_array_aggregate(
        json_object({ id: 'o.id', ordered_at: 'o.created_at' }),
      ),
      '[]',
    ),
  )
  .where('order.user_id', unescape('u.id'))
  .orderBy('o.created_at', 'desc')
  .limit(5)
  .toSQL()
Copy