News for hackers. Stuff that matters.
Re:Ask HN: How do you test SQL? by jph00 on Tuesday January 31, 2023 @06:59PM (#34604196)
CTE==Common Table Expression. It's not specific to any particular language. It's basically like a view, except you can define them the same place as you use them, and they can be recursive.
Re:Ask HN: How do you test SQL? by jimmygrapes on Tuesday January 31, 2023 @07:40PM (#34604605)
Thank you for the clarification, that actually makes sense in context!

... Although also now I'm a little. put off because you reminded me of working with DOS-based SAP interfaces and Oracle's Java-based attempts to make "interactive views" circa 2006 :/