Date Scaffolding and Non-Equi Joins at DB Level

This might be a question to @takbb, have been using the “Join Custom Condition - indexed - takbb” component with good results over the past year after your recommendation in this thread.

I now have the opportunity to push the logic to the DB (H2) level. Wondering if I can get any pointers or things to watch out for. I imagine a straight SQL query should do the trick, but the component itself is a maze within, so I’m wondering if I’m missing something in the complexity of the challenge.