Have you benchmarked it on your own with newer PSQL? You can also use
LATERALinJOINto simulateEXISTSwith current Ecto.
I haven’t benchmarked the blog post’s example, but I have definitely benchmarked my code and the equivalent logic implemented in joins is significantly slower. That is a good point about the lateral join though. If I can’t do it with macros I’ll try that, although converting a complex series of exists and not exists might be difficult.
