Function exists

Create EXISTS condition expression.

import { createBuilder, exists } from 'coral-sql'

const [sql, bindings] = createBuilder()
  .from('users')
  .where('id', exists(
    createBuilder()
      .from('orders')
      .where('orders.user_id', 'users.id')
      .where('orders.status', 'completed')
  ))
  .toSQL()
// sql: SELECT * FROM `users` WHERE `id` EXISTS (SELECT * FROM `orders` WHERE `orders.user_id` = `users.id` AND `orders.status` = ?)
// bindings: ['completed']
Copy