adonis query builder code example

Example 1: adonis lucid join

await Database
  .table('users')
  .innerJoin('accounts', 'user.id', 'accounts.user_id')

Example 2: adonis andwhere

payments.where('amount', '>', 1000).andWhere('type', 'CASH')