News for hackers. Stuff that matters.
Re:Ask HN: How do you test SQL? by xpil on Wednesday February 01, 2023 @07:14AM (#34609451)
> (...) in subsequent SELECT, DELETE, INSERT, or UPDATE statements

The annoying part is that certain RDMBS engines (MySQL for instance) require you to write the INSERT keyword before any CTEs.

So, your T-SQL or PGSQL query:

`with cte1 as (...) insert into ... select ... from cte1;`

becomes:

`insert into ... with cte1 as (...) select ... from cte1;`

I know the difference is minor but when you deal with many different DB engines, it is simply annoying.

There are no comments on this comment yet.