0.19.5

Add support for lateral joins

const query = ctx.db
  .selectFrom('person')
  .innerJoinLateral(
    (eb) =>
      eb.selectFrom('pet')
        .select('name')
        .whereRef('pet.owner_id', '=', 'person.id')
        .as('p'),
    (join) => join.on(sql`true`)
  )
  .select(['first_name', 'p.name'])
  .orderBy('first_name')