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!
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
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!