Personally, I think ORM has a reasonable use case here, but I also find doing this using SQL to be straightforward and easier to reason about during future refa

Personally, I think ORM has a reasonable use case here, but I also find doing this using SQL to be straightforward and easier to reason about during future refactors. Take a look at JDBI's Repository pattern for a simple compromise between SQL and ORM for this use case in particular.