Where clauses

Chaining wheres

Kotlin

ShopTable
    .where(ShopTable.id eq hardwareStoreId)
    .where(ShopTable.name eq "Helen's Hardware")
    .perform(db)
    .single()

SQL

SELECT T0."id" c0
, T0."name" c1
, T0."address" c2
, T0."established" c3
FROM "Shop" T0
WHERE (T0."id" = 1) AND (T0."name" = 'Helen\'s Hardware')