Allow the direct use of WITH CTEs with the IN operator in Drift files about drift HOT 4 CLOSED

Thanks for the report, I've released version 0.35.1 of sqlparser to fix this.

from drift.

Oh nice, I didn't know that was a thing! This will be allowed with the next release.

from drift.

Neither did I: I found out by accident, but it's pretty useful. Thank you for the quick turnaround on this one!

It only works if there's only a single column in the CTE, from what I understand.

As in, this works:

WITH names AS (
  SELECT name FROM persons
)

SELECT
  *,
  'John' IN names AS john_exists
FROM my_table

Whereas this does not:

WITH names AS (
  SELECT name, surname FROM persons
)

SELECT
  *,
  'John' IN names AS john_exists
FROM my_table

But from what I understand looking at your commit, you do include such a column comparison already, so it should all be good :)

from drift.

@simolus3 hey, unfortunately this does not work properly in the 2.17 release. The column name in the generated data class is incorrect (the data contained therein is fine, though)

It looks like it gets resolved to the textual content of the whole line, i.e. johninnamesASjohnExists, instead of just everything after AS, i.e. johnExists.

from drift.