forked from tidyverse/dplyr
-
Notifications
You must be signed in to change notification settings - Fork 0
/
backend_sql.Rd
41 lines (34 loc) · 1 KB
/
backend_sql.Rd
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
% Generated by roxygen2: do not edit by hand
% Please edit documentation in R/sql-generic.R
\name{backend_sql}
\alias{backend_sql}
\alias{sql_escape_ident}
\alias{sql_escape_string}
\alias{sql_join}
\alias{sql_select}
\alias{sql_semi_join}
\alias{sql_set_op}
\alias{sql_subquery}
\title{SQL generation.}
\usage{
sql_select(con, select, from, where = NULL, group_by = NULL,
having = NULL, order_by = NULL, limit = NULL, distinct = FALSE, ...)
sql_subquery(con, from, name = random_table_name(), ...)
sql_join(con, x, y, type = "inner", by = NULL, ...)
sql_semi_join(con, x, y, anti = FALSE, by = NULL, ...)
sql_set_op(con, x, y, method)
sql_escape_string(con, x)
sql_escape_ident(con, x)
}
\arguments{
\item{con}{A database connection.}
}
\value{
An SQL string.
}
\description{
These generics are used to run build various SQL queries. A default method
generates ANSI 92 compliant SQL, but variations in SQL across databases means
that it's likely that a backend will require at least a few methods.
}
\keyword{internal}