re: Why I use SQL Common Table Expressions (CTEs) VIEW POST


I didn't know about CTEs but luckily now I do.

I'm glad you also mentioned that CTEs are all about readability. I was worried that I'd be missing out on some great functionality because of pre-defined ORMs in the frameworks I work with keeping me from having real decision making in the way queries are structured.

I already have some real-life use cases in which I could apply CTEs to make the temporary queries I have to write for some kind of export, debugging purposes or any other reason more readable. It'll help both myself and my colleagues a lot, thank you!

code of conduct - report abuse