Run a SQL Query script on the CHILDES database

get_sql_query(
  sql_query_string,
  connection = NULL,
  db_version = "current",
  db_args = NULL
)

Arguments

sql_query_string

A valid sql query string character

connection

A connection to the CHILDES database

db_version

String of the name of database version to use

db_args

List with host, user, and password defined

Value

The database after calling the supplied SQL query

Examples

# \donttest{ get_sql_query("SELECT * FROM collection")
#> Using current database version: '2020.1'.
#> # A tibble: 33 x 3 #> id name data_source #> <int> <chr> <chr> #> 1 1 Frogs CHILDES #> 2 2 Eng-NA CHILDES #> 3 3 Scandinavian CHILDES #> 4 4 Spanish CHILDES #> 5 5 French CHILDES #> 6 6 DutchAfrikaans CHILDES #> 7 7 Chinese CHILDES #> 8 8 Other CHILDES #> 9 9 Japanese CHILDES #> 10 10 Romance CHILDES #> # … with 23 more rows
# }