Managing complex business logic in SQL using Common Table Expressions (CTEs)

[bubblehack3r]

https://www.swarmia.com/blog/managing-complex-business-logic-with-ctes/

[bob1029]

We do a ton of complex biz rule SQL, and CTEs are something we do dabble in today (w/ SQLite).

After reading this article, I think I want to push this idea a lot harder on the team. Seems there is a more elegant pattern that may emerge if you go further into this rabbit hole.