Execute a SQL query scoped to a particular dataset. Table names do not need to be fully qualified, since all tables are assumed to be within the dataset.
Parameters:
query_string : strThe SQL query to execute. Must follow the .
dataset <- redivis$organization("Demo")$dataset("CMS 2014 Medicare Data")query = dataset$query(" SELECT hospice_providers.name, inpatient_charges.drg_definition -- The tables inpatient_chargers, hospice_providers are assumed to be -- within the scoped dataset FROM inpatient_charges INNER JOIN hospice_providers ON hospice_providers.provider_id = inpatient_charges.provider_id")print(query$to_tibble())