I’d like to be able to build a query using OrmLite with the following format:
SELECT *
FROM TABLE
WHERE (FirstCol = 2)
AND (SecondCol LIKE '%some_string%' OR SecondCol LIKE '%some_other_string%')
Is it possible to build the query with a SqlExpression
so that I can have a clause that is joined with an AND
but internally contains OR
s?
Update
I see that someone has asked a similar question a few years ago.