Does the sql ide support jumping to CTEs?
Does the sql ide support jumping to a CTEs (common table expression) from another part of the query but within the same file?
Hey Joyce Chan , Mode does support working with CTEs. You can write them the way you would normally write them for your database.
In general, SQL that works directly in your database will also work in Mode, since Mode sends the queries you write directly to your database for interpreting, with very little parsing on Mode's end. Just note that in Mode, a query can contain only one SQL statement.