1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
SELECT a FROM x;
SELECT "a" FROM "x";
SELECT "a" FROM "x";
SELECT "a" FROM "x";
SELECT x.a AS a FROM db.x;
SELECT "x"."a" AS "a" FROM "db"."x";
SELECT @x;
SELECT @x;
# dialect: snowflake
SELECT * FROM DUAL;
SELECT * FROM DUAL;
# dialect: snowflake
SELECT * FROM "DUAL";
SELECT * FROM "DUAL";
# dialect: snowflake
SELECT * FROM "dual";
SELECT * FROM "dual";
# dialect: snowflake
SELECT dual FROM t;
SELECT "dual" FROM "t";
# dialect: snowflake
SELECT * FROM t AS dual;
SELECT * FROM "t" AS "dual";
# dialect: bigquery
SELECT `p.d.udf`(data).* FROM `p.d.t`;
SELECT `p.d.udf`(`data`).* FROM `p.d.t`;
|
