Lucid: Writing complex 'where' conditions using parentheses

[msrumon]

My targeted query:

select * from `products` where `classification` = 'stock' and `species` = 'photo' and `status` = 'approved' and `owned_by` is null and (`title` like '%color%' or `keywords` like '%color%') order by `created_at` desc;

My current code:

const products = await Product.query()
  .where({
    classification,
    species,
    status: 'approved',
    owned_by: null,
  })
  .andWhere('title', 'like', `%${q}%`)
  .orWhere('keywords', 'like', `%${q}%`)
  .orderBy('created_at', 'desc')
  .preload('prices', (builder) => builder.preload('invoices'))
  .preload('seller')
  .debug(true);

...which executes the following query:

"mysql" Product (4.14 ms) select * from `products` where `classification` = ? and `species` = ? and `status` = ? and `owned_by` is null and `title` like ? or `keywords` like ? order by `created_at` desc [ 'stock', 'photo', 'approved', '%color%', '%color%' ]

Look at the parentheses around last conditions in the target query. Is it achievable w/o using raw query builder in v5?

[msrumon]

Never knew I could write functions inside andWhere(). This is the targeted code:

const products = await Product.query()
  .where({
    classification,
    species,
    status: 'approved',
    owned_by: null,
  })
  // .andWhere('title', 'like', `%${q}%`)
  // .orWhere('keywords', 'like', `%${q}%`)
  .andWhere((builder) =>
    builder
      .where('title', 'like', `%${q}%`)
      .orWhere('keywords', 'like', `%${q}%`)
  )
  .orderBy('created_at', 'desc')
  .preload('prices', (builder) => builder.preload('invoices'))
  .preload('seller')
  .debug(true);