Kysely•2y ago•

7 replies

Using raw SQL with `or` where

I have been using the raw SQL template tag to work with certain JSON columns and wanted to add a

orWhere

orWhere

clause using it. Here is a simple example of what I am trying to achieve.

const result = await db
  .selectFrom('users')
  .where((eb) => {
    return eb.or([
      sql`address ->> 'street' = ${street}`,
      sql`address ->> 'street' = ${street1}`
    ])
  })
  .executeTakeFirst()

const result = await db
  .selectFrom('users')
  .where((eb) => {
    return eb.or([
      sql`address ->> 'street' = ${street}`,
      sql`address ->> 'street' = ${street1}`
    ])
  })
  .executeTakeFirst()

I can pass

sql

sql

literal to the

where

where

clause directly, but in this case I want to write

or

or

where

Solution

And you're right,

eb.or

eb.or

expects a list of

Expression<SqlBool>

Expression<SqlBool>

where

SqlBool

SqlBool

boolean | 0 | 1

boolean | 0 | 1

Jump to solution

Kysely•2y ago•

7 replies

virk

Using raw SQL with `or` where

I have been using the raw SQL template tag to work with certain JSON columns and wanted to add a

orWhere

orWhere

clause using it. Here is a simple example of what I am trying to achieve.

const result = await db
  .selectFrom('users')
  .where((eb) => {
    return eb.or([
      sql`address ->> 'street' = ${street}`,
      sql`address ->> 'street' = ${street1}`
    ])
  })
  .executeTakeFirst()

const result = await db
  .selectFrom('users')
  .where((eb) => {
    return eb.or([
      sql`address ->> 'street' = ${street}`,
      sql`address ->> 'street' = ${street1}`
    ])
  })
  .executeTakeFirst()

I can pass

sql

sql

literal to the

where

where

clause directly, but in this case I want to write

or

or

where

Solution

And you're right,

eb.or

eb.or

expects a list of

Expression<SqlBool>

Expression<SqlBool>

where

SqlBool

SqlBool

boolean | 0 | 1

boolean | 0 | 1

Jump to solution

Using raw SQL with `or` where

Similar Threads

Using raw SQL with `or` where

Similar Threads

Similar Threads

Similar Threads