Function json_array_aggregate

Create JSON_ARRAYAGG expression.

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

const [sql, bindings] = createBuilder()
  .from('orders')
  .column(
    json_array_aggregate(
      json_object({ id: 'id', total: 'total_amount' }),
      'with_coalesce'
    )
  )
  .toSQL()
// sql: SELECT COALESCE(JSON_ARRAYAGG(JSON_OBJECT('id', `id`, 'total', `total_amount`)), '[]') FROM `orders`
Copy

Create JSON_ARRAYAGG expression.

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

const [sql, bindings] = createBuilder()
  .from('orders')
  .column(
    json_array_aggregate(
      json_object({ id: 'id', total: 'total_amount' }),
      'with_coalesce'
    )
  )
  .toSQL()
// sql: SELECT COALESCE(JSON_ARRAYAGG(JSON_OBJECT('id', `id`, 'total', `total_amount`)), '[]') FROM `orders`
Copy