SQL is great, but you do have to dig deeper and use more of its features, like many other comments mentioned, like WITH & VIEWs. On the other hand, maybe the t

SQL is great, but you do have to dig deeper and use more of its features, like many other comments mentioned, like WITH & VIEWs. On the other hand, maybe the time is ripe for you to "graduate" to using Datalog via other kind of databases, like Datomic, XTDB (fka Crux) and the likes (DataScript, Datalevin, etc) Of course knowing Datalog won't help you with your SQL issues, but you can look into changing jobs, if you like what you see or maybe do some ETL job to spill over some data into the mentioned DBs and see whether querying it with Datalog is any better.