get_sql_query: Run a SQL Query script on the CHILDES database

In childesr: Accessing the 'CHILDES' Database

Run a SQL Query script on the CHILDES database

Description

As of childesr 0.3, queries run against the childes-db dataset on Redivis, whose query engine uses BigQuery Standard SQL rather than MySQL SQL. Standard SQL queries against the childes-db tables ('collection', 'corpus', 'transcript', 'participant', 'transcript_by_speaker', 'utterance', 'token', 'token_frequency') work unchanged; queries using MySQL-specific syntax may need to be updated (see https://cloud.google.com/bigquery/docs/reference/standard-sql/).

Usage

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

Arguments

sql_query_string	A valid BigQuery Standard SQL query string
connection	Deprecated, ignored (childesr now reads from the childes-db dataset on Redivis)
db_version	String of the name of database version to use
db_args	Deprecated, ignored

Value

The result of running the supplied SQL query on the childes-db dataset

Examples

## Not run: 
get_sql_query("SELECT * FROM collection")

## End(Not run)

childesr documentation built on Sept. 16, 2026, 9:09 a.m.