Performance Consideration with `WITH` clause (CTE) and `IN` operator
Previously, I’ve been using separate code for MySQL and SQLite when using the WITH clause and IN operator. I use IN (TABLE cte) in MySQL and IN cte in SQLite.
Previously, I’ve been using separate code for MySQL and SQLite when using the WITH clause and IN operator. I use IN (TABLE cte) in MySQL and IN cte in SQLite.