Run an arbitrary SQL query against a SemsqlConn database

run_query(x, sql, ...)

Arguments

x: A SemsqlConn object.
sql: character(1) SQL query string.
...: not used

Value

data.frame with query results.

Examples

goref <- semsql_connect(ontology = "go")
#> Connected to SemanticSQL database: /home/runner/.cache/R/BiocFileCache/51aa7efd341e_go.db
#> Primary ontology prefix: GO
run_query(
  goref,
  "SELECT subject, value AS label FROM rdfs_label_statement LIMIT 5"
)
#>       subject             label
#> 1 IAO:0000115        definition
#> 2 IAO:0000115        definition
#> 3 IAO:0000116       editor note
#> 4 IAO:0000233 term tracker item
#> 5 IAO:0000233 term tracker item
disconnect(goref)
#> Disconnected from '51aa7efd341e_go.db'