14.9. The where clause

from Cat where name='Fritz'

from Cat as cat where cat.name='Fritz'

select foo
from Foo foo, Bar bar
where foo.startDate = bar.date

from Cat cat where cat.mate.name is not null

from Foo foo
where foo.bar.baz.customer.address.city is not null

from Cat cat, Cat rival where cat.mate = rival.mate

select cat, mate
from Cat cat, Cat mate
where cat.mate = mate

from Cat as cat where cat.id = 123

from Cat as cat where cat.mate.id = 69

from bank.Person person
where person.id.country = 'AU'
    and person.id.medicareNumber = 123456

from bank.Account account
where account.owner.id.country = 'AU'
    and account.owner.id.medicareNumber = 123456

from Cat cat where cat.class = DomesticCat

from AuditLog log, Payment payment
where log.item.class = 'Payment' and log.item.id = payment.id