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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
|
# can translate case insensitive like
Code
translate_sql(str_like(x, "abc", ignore_case = FALSE))
Condition
Error in `str_like()`:
! Backend only supports case insensitve `str_like()`.
# default raw escapes translated correctly
Code
mf %>% filter(x == a)
Output
<SQL>
SELECT *
FROM `df`
WHERE (`x` = X'616263')
---
Code
mf %>% filter(x %in% L)
Output
<SQL>
SELECT *
FROM `df`
WHERE (`x` IN (X'616263', X'0102'))
---
Code
qry
Output
<SQL>
SELECT *
FROM `df`
WHERE (`x` IN (X'616263', X'0102'))
# DDL operations generate expected SQL
Code
sql_table_analyze(con, in_schema("schema", "tbl"))
Output
<SQL> ANALYZE `schema`.`tbl`
---
Code
sql_query_explain(con, sql("SELECT * FROM foo"))
Output
<SQL> EXPLAIN SELECT * FROM foo
---
Code
sql_query_wrap(con, ident("table"))
Output
<IDENT> table
---
Code
sql_query_wrap(con, in_schema("schema", "tbl"))
Output
<IDENT> `schema`.`tbl`
---
Code
sql_query_wrap(con, sql("SELECT * FROM foo"))
Output
<SQL> (SELECT * FROM foo) `q01`
---
Code
sql_table_index(con, in_schema("schema", "tbl"), c("a", "b"))
Output
<SQL> CREATE INDEX `schema_tbl_a_b` ON `schema`.`tbl` (`a`, `b`)
---
Code
sql_table_index(con, in_schema("schema", "tbl"), "c", unique = TRUE)
Output
<SQL> CREATE UNIQUE INDEX `schema_tbl_c` ON `schema`.`tbl` (`c`)
---
Code
sql_query_save(con, sql("SELECT * FROM foo"), in_schema("temp", "tbl"))
Output
<SQL> CREATE TEMPORARY TABLE
`temp`.`tbl` AS
SELECT * FROM foo
|
