yotov_db: The local Yotov database
In yotover: An Advanced Guide to Trade Policy Analysis

Returns a connection to the local yotov database. This is a DBI-compliant duckdb database connection. When using dplyr-based workflows, one typically accesses tables with yotov_data(), but this function lets the user interact with the database directly via SQL.

1	yotov_db(dbdir = yotov_path())

dbdir

The location of the database on disk. Defaults to yotovdb under rappdirs::user_data_dir(), or the environment variable yotov_DB_DIR.

if (yotov_status()) {
  DBI::dbListTables(yotov_db())

  ch1_application1 <- DBI::dbReadTable(yotov_db(), "ch1_application1")

  DBI::dbGetQuery(
    yotov_db(),
    "SELECT * FROM ch1_application1"
  )
}