TIL: How to join to subqueries with OrmLite

from blog Just Some Code, | ↗ original
Another day working with OrmLite. This time, I needed to support a report page with a list of dynamic filters and sorting fields. Instead of writing a plain SQL query, I needed to write a SqlExpression that joins to a subquery. OrmLite doesn’t support that. This is what I learned (or hacked) today. Let’s imagine we need to write an SQL query for...