| query |
    query := SimpleQuery
                read: GptRepositor
                where: [ :each |
                    ((each firstName like: '%one%') OR: [
                        (each firstName like: '%two%' )
                         OR: [each firstName like: '%three%']])
                    AND: [
                        ((each firstName like: '%four%') OR: [
                        (each firstName like: '%five%' )
                         OR: [each firstName like: '%six%']])
                    ]
                ].
    query executeIn: session.
    ].

"
Produces:
SELECT t1.id, t1.user_id, t1.firstName, t1.lastName, t1.supervisor_id, t1.weeklyHours, t1.category, t1.contract, t1.alias1, t1.alias2, t1.alias3
 FROM REPOSITOR t1
 WHERE (((t1.firstName LIKE '%one%') OR ((t1.firstName LIKE '%two%') OR (t1.firstName LIKE '%three%'))) AND ((t1.firstName LIKE '%four%') OR ((t1.firstName LIKE '%five%') OR (t1.firstName LIKE '%six%'))))"