{ "_id": "6a12a829acfb0bcc41d15245", "Type": "Package", "Package": "dbplyr", "Title": "A 'dplyr' Back End for Databases", "Version": "2.5.2.9000", "Authors@R": "c(\nperson(\"Hadley\", \"Wickham\", , \"hadley@posit.co\", role = c(\"aut\", \"cre\")),\nperson(\"Maximilian\", \"Girlich\", role = \"aut\"),\nperson(\"Edgar\", \"Ruiz\", role = \"aut\"),\nperson(\"Posit Software, PBC\", role = c(\"cph\", \"fnd\"))\n)", "Description": "A 'dplyr' back end for databases that allows you to work\nwith remote database tables as if they are in-memory data\nframes. Basic features works with any database that has a\n'DBI' back end; more advanced features require 'SQL'\ntranslation to be provided by the package author.", "License": "MIT + file LICENSE", "URL": "https://dbplyr.tidyverse.org/, https://github.com/tidyverse/dbplyr", "BugReports": "https://github.com/tidyverse/dbplyr/issues", "VignetteBuilder": "knitr", "Config/Needs/website": "tidyverse/tidytemplate", "Config/testthat/edition": "3", "Config/testthat/parallel": "TRUE", "Encoding": "UTF-8", "Language": "en-gb", "Roxygen": "list(markdown = TRUE)", "Collate": "'verb-copy-inline.R' 'verb-copy-to.R' 'db-sql.R' 'db.R'\n'utils-check.R' 'import-standalone-types-check.R'\n'import-standalone-obj-type.R' 'utils.R' 'sql.R' 'escape.R'\n'translate-sql-cut.R' 'translate-sql-string.R'\n'translate-sql-aggregate.R' 'translate-sql-scalar.R'\n'translate-sql-helpers.R' 'translate-sql-window.R'\n'translate-sql-conditional.R' 'backend-.R' 'backend-access.R'\n'backend-adbc.R' 'backend-db2.R' 'backend-hana.R'\n'backend-hive.R' 'backend-impala.R' 'backend-jdbc.R'\n'backend-mssql.R' 'backend-mysql.R' 'backend-odbc.R'\n'backend-oracle.R' 'backend-postgres.R'\n'backend-postgres-old.R' 'backend-redshift.R'\n'backend-snowflake.R' 'backend-spark-sql.R' 'backend-sqlite.R'\n'backend-teradata.R' 'backward-compatibility.R'\n'bind-queries.R' 'data-cache.R' 'data-lahman.R'\n'data-nycflights13.R' 'db-io.R' 'dbplyr.R' 'ident.R'\n'import-standalone-s3-register.R' 'join-by-compat.R'\n'join-cols-compat.R' 'lazy-ops.R' 'memdb.R' 'optimise-utils.R'\n'progress.R' 'query-base.R' 'query-join.R' 'query-rf-join.R'\n'query-select.R' 'query-semi-join.R' 'query-set-op.R'\n'query-union.R' 'query.R' 'remote.R' 'rows.R' 'schema.R'\n'sql-build.R' 'sql-clause.R' 'sql-dialect.R' 'sql-glue.R'\n'sql-quote.R' 'sql-superseded.R' 'src-sql.R' 'src_dbi.R'\n'table-name.R' 'tbl-lazy.R' 'tbl-sql.R' 'tidyeval-across.R'\n'tidyeval.R' 'translate-sql.R' 'utils-format.R'\n'verb-arrange.R' 'verb-collapse.R' 'verb-collect.R'\n'verb-compute.R' 'verb-count.R' 'verb-distinct.R'\n'verb-do-query.R' 'verb-do.R' 'verb-expand.R' 'verb-explain.R'\n'verb-fill.R' 'verb-filter.R' 'verb-group_by.R' 'verb-head.R'\n'verb-joins.R' 'verb-mutate.R' 'verb-pivot-longer.R'\n'verb-pivot-wider.R' 'verb-pull.R' 'verb-select.R'\n'verb-set-ops.R' 'verb-slice.R' 'verb-summarise.R'\n'verb-uncount.R' 'verb-window.R' 'with-dialect.R' 'zzz.R'", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "libicu-dev", "Repository": "https://tidyverse.r-universe.dev", "Date/Publication": "2026-05-20 13:01:12 UTC", "RemoteUrl": "https://github.com/tidyverse/dbplyr", "RemoteRef": "HEAD", "RemoteSha": "f52aaa9627096262e692d3c4974a29669c855095", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-24 06:51:07 UTC", "User": "root" }, "Author": "Hadley Wickham [aut, cre],\nMaximilian Girlich [aut],\nEdgar Ruiz [aut],\nPosit Software, PBC [cph, fnd]", "Maintainer": "Hadley Wickham ", "MD5sum": "d167d6c657a5331180500c3fba05d3d3", "_user": "tidyverse", "_type": "src", "_file": "dbplyr_2.5.2.9000.tar.gz", "_fileid": "4c48d7176b520523bc36f6bcdbcee2696deb89b8f4a4087b3667f0f3a2eb025e", "_filesize": 954612, "_sha256": "4c48d7176b520523bc36f6bcdbcee2696deb89b8f4a4087b3667f0f3a2eb025e", "_created": "2026-05-24T06:51:07.000Z", "_published": "2026-05-24T07:26:33.729Z", "_distro": "noble", "_jobs": [ { "job": 77578485244, "time": 203, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7183035376" }, { "job": 77578485249, "time": 210, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7183036130" }, { "job": 77578485247, "time": 151, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7183249114" }, { "job": 77578485243, "time": 114, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7183240761" }, { "job": 77578291260, "time": 222, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7183014540" }, { "job": 77578485253, "time": 116, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7183026730" }, { "job": 77578485255, "time": 192, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7183034506" }, { "job": 77578485254, "time": 152, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7183030201" }, { "job": 77578485256, "time": 298, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7183044816" } ], "_buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/tidyverse/dbplyr", "_commit": { "id": "f52aaa9627096262e692d3c4974a29669c855095", "author": "Hadley Wickham ", "committer": "Hadley Wickham ", "message": "Add some missing issue/PR numbers\n", "time": 1779282072 }, "_maintainer": { "name": "Hadley Wickham", "email": "hadley@posit.co", "login": "hadley", "bluesky": "@hadley.nz", "description": "Chief Scientist at @posit-pbc", "uuid": 4196 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1", "role": "Depends" }, { "package": "blob", "version": ">= 1.2.0", "role": "Imports" }, { "package": "cli", "version": ">= 3.6.1", "role": "Imports" }, { "package": "DBI", "version": ">= 1.1.3", "role": "Imports" }, { "package": "dplyr", "version": ">= 1.1.2", "role": "Imports" }, { "package": "glue", "version": ">= 1.6.2", "role": "Imports" }, { "package": "lifecycle", "version": ">= 1.0.3", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "pillar", "version": ">= 1.9.0", "role": "Imports" }, { "package": "purrr", "version": ">= 1.0.1", "role": "Imports" }, { "package": "R6", "version": ">= 2.2.2", "role": "Imports" }, { "package": "rlang", "version": ">= 1.1.1", "role": "Imports" }, { "package": "tibble", "version": ">= 3.2.1", "role": "Imports" }, { "package": "tidyr", "version": ">= 1.3.0", "role": "Imports" }, { "package": "tidyselect", "version": ">= 1.2.1", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "vctrs", "version": ">= 0.6.3", "role": "Imports" }, { "package": "withr", "version": ">= 2.5.0", "role": "Imports" }, { "package": "adbcdrivermanager", "role": "Suggests" }, { "package": "adbcsqlite", "role": "Suggests" }, { "package": "adbi", "role": "Suggests" }, { "package": "bit64", "role": "Suggests" }, { "package": "covr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "Lahman", "role": "Suggests" }, { "package": "nycflights13", "role": "Suggests" }, { "package": "odbc", "version": ">= 1.4.2", "role": "Suggests" }, { "package": "RJDBC", "role": "Suggests" }, { "package": "RMariaDB", "version": ">= 1.2.2", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RPostgres", "version": ">= 1.4.5", "role": "Suggests" }, { "package": "RPostgreSQL", "role": "Suggests" }, { "package": "RSQLite", "version": ">= 2.3.8", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.1.10", "role": "Suggests" } ], "_owner": "tidyverse", "_selfowned": true, "_usedby": 804, "_updates": [ { "week": "2025-33", "n": 1 }, { "week": "2025-36", "n": 3 }, { "week": "2025-37", "n": 5 }, { "week": "2025-47", "n": 3 }, { "week": "2025-48", "n": 13 }, { "week": "2025-49", "n": 25 }, { "week": "2025-50", "n": 19 }, { "week": "2025-51", "n": 30 }, { "week": "2025-52", "n": 28 }, { "week": "2026-01", "n": 13 }, { "week": "2026-02", "n": 6 }, { "week": "2026-03", "n": 14 }, { "week": "2026-04", "n": 4 }, { "week": "2026-07", "n": 3 }, { "week": "2026-20", "n": 16 }, { "week": "2026-21", "n": 11 } ], "_tags": [ { "name": "v2.5.1", "date": "2025-09-09" }, { "name": "v2.5.2", "date": "2026-02-13" } ], "_topics": [ "database" ], "_stars": 508, "_contributors": [ { "user": "hadley", "count": 2357, "uuid": 4196 }, { "user": "romainfrancois", "count": 649, "uuid": 2625526 }, { "user": "krlmlr", "count": 165, "uuid": 1741643 }, { "user": "lionel-", "count": 101, "uuid": 4465050 }, { "user": "mgirlich", "count": 50, "uuid": 18258854 }, { "user": "edgararuiz", "count": 38, "uuid": 77294576 }, { "user": "colearendt", "count": 23, "uuid": 23075542 }, { "user": "lindbrook", "count": 17, "uuid": 6076793 }, { "user": "jimhester", "count": 16, "uuid": 205275 }, { "user": "batpigandme", "count": 16, "uuid": 831732 }, { "user": "hannes", "count": 13, "uuid": 227792 }, { "user": "edward-burn", "count": 12, "uuid": 9583964 }, { "user": "kevinushey", "count": 10, "uuid": 1976582 }, { "user": "ejneer", "count": 8, "uuid": 15007591 }, { "user": "ilarischeinin", "count": 7, "uuid": 2540173 }, { "user": "javierluraschi", "count": 7, "uuid": 3478847 }, { "user": "michaelchirico", "count": 7, "uuid": 7606389 }, { "user": "sfirke", "count": 6, "uuid": 7569808 }, { "user": "cosinequanon", "count": 6, "uuid": 1226424 }, { "user": "simonpcouch", "count": 6, "uuid": 35748691 }, { "user": "leondutoit", "count": 5, "uuid": 1214931 }, { "user": "dpprdan", "count": 4, "uuid": 1423562 }, { "user": "zeehio", "count": 4, "uuid": 75441 }, { "user": "pimentel", "count": 4, "uuid": 530217 }, { "user": "eibanez", "count": 4, "uuid": 438494 }, { "user": "cderv", "count": 4, "uuid": 6791940 }, { "user": "arunsrinivasan", "count": 4, "uuid": 3102045 }, { "user": "rbdixon", "count": 3, "uuid": 35279 }, { "user": "imanuelcostigan", "count": 3, "uuid": 2107580 }, { "user": "fh-mthomson", "count": 3, "uuid": 56164984 }, { "user": "shosaco", "count": 3, "uuid": 20717764 }, { "user": "fh-afrachioni", "count": 3, "uuid": 83310246 }, { "user": "austenhead", "count": 3, "uuid": 6146404 }, { "user": "davidpatshuifong", "count": 3, "uuid": 8335820 }, { "user": "mtoto", "count": 2, "uuid": 10297043 }, { "user": "uribo", "count": 2, "uuid": 228649 }, { "user": "rsund", "count": 2, "uuid": 7668641 }, { "user": "owenjonesuob", "count": 2, "uuid": 21007837 }, { "user": "nicolascoutin", "count": 2, "uuid": 141983255 }, { "user": "mkearney", "count": 2, "uuid": 13401460 }, { "user": "ablack3", "count": 2, "uuid": 10227522 }, { "user": "thomashulst", "count": 2, "uuid": 32511519 }, { "user": "xiaodaigh", "count": 2, "uuid": 4497189 }, { "user": "zacdav-db", "count": 2, "uuid": 80654433 }, { "user": "erikvona", "count": 2, "uuid": 45684074 }, { "user": "shabbybanks", "count": 2, "uuid": 23323752 }, { "user": "okhoma", "count": 2, "uuid": 212077 }, { "user": "davisvaughan", "count": 2, "uuid": 19150088 }, { "user": "derekmorr", "count": 2, "uuid": 6717579 }, { "user": "earino", "count": 2, "uuid": 3258 }, { "user": "alistaire47", "count": 2, "uuid": 1693477 }, { "user": "edwindj", "count": 2, "uuid": 542492 }, { "user": "hdplsa", "count": 2, "uuid": 737177 }, { "user": "ianmcook", "count": 2, "uuid": 280509 }, { "user": "jeroenjanssens", "count": 2, "uuid": 1368256 }, { "user": "kevinykuo", "count": 2, "uuid": 5582151 }, { "user": "justmarkham", "count": 2, "uuid": 6509492 }, { "user": "zozlak", "count": 2, "uuid": 6503177 }, { "user": "mkuhn", "count": 2, "uuid": 7827 }, { "user": "nhanitvn", "count": 1, "uuid": 1751491 }, { "user": "noamross", "count": 1, "uuid": 571752 }, { "user": "ossilehtinen", "count": 1, "uuid": 16836852 }, { "user": "shearerpmm", "count": 1, "uuid": 7192213 }, { "user": "paulstaab", "count": 1, "uuid": 2339377 }, { "user": "paulojhonny", "count": 1, "uuid": 14023635 }, { "user": "rplsmn", "count": 1, "uuid": 74007913 }, { "user": "robertzk", "count": 1, "uuid": 1638492 }, { "user": "overmar", "count": 1, "uuid": 30846621 }, { "user": "robinlovelace", "count": 1, "uuid": 1825120 }, { "user": "russellpierce", "count": 1, "uuid": 1847158 }, { "user": "yutannihilation", "count": 1, "uuid": 1978793 }, { "user": "nathanhaigh", "count": 1, "uuid": 2037575 }, { "user": "mine-cetinkaya-rundel", "count": 1, "uuid": 5965649 }, { "user": "mikejohnpage", "count": 1, "uuid": 38110953 }, { "user": "mtreadwell", "count": 1, "uuid": 10984846 }, { "user": "mdsumner", "count": 1, "uuid": 4107631 }, { "user": "mkuehn10", "count": 1, "uuid": 4229651 }, { "user": "mnel", "count": 1, "uuid": 402025 }, { "user": "maelle", "count": 1, "uuid": 8360597 }, { "user": "matthewjnield", "count": 1, "uuid": 64328730 }, { "user": "mattle24", "count": 1, "uuid": 10014947 }, { "user": "washcycle", "count": 1, "uuid": 1075710 }, { "user": "sandan", "count": 1, "uuid": 5252351 }, { "user": "teramonagi", "count": 1, "uuid": 683736 }, { "user": "shearerp", "count": 1, "uuid": 93137416 }, { "user": "shea-parkes", "count": 1, "uuid": 5782892 }, { "user": "mnfn", "count": 1, "uuid": 7197452 }, { "user": "klmedeiros", "count": 1, "uuid": 16199504 }, { "user": "hs3180", "count": 1, "uuid": 1643451 }, { "user": "hoxo-m", "count": 1, "uuid": 7479163 }, { "user": "harrismcgehee", "count": 1, "uuid": 9814456 }, { "user": "agable-vt", "count": 1, "uuid": 34289644 }, { "user": "fh-kpikhart", "count": 1, "uuid": 58270600 }, { "user": "eitsupi", "count": 1, "uuid": 50911393 }, { "user": "eipi10", "count": 1, "uuid": 436817 }, { "user": "edgararuiz-zz", "count": 1, "uuid": 7875923 }, { "user": "pachevalier", "count": 1, "uuid": 3227753 }, { "user": "avsdev-cw", "count": 1, "uuid": 25663960 }, { "user": "zachary-foster", "count": 1, "uuid": 6090555 }, { "user": "sverchkov", "count": 1, "uuid": 2293026 } ], "_userbio": { "uuid": 22032646, "type": "organization", "name": "tidyverse", "description": "The tidyverse is a collection of R packages that share common principles and are designed to work together seamlessly" }, "_downloads": { "count": 527238, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dbplyr" }, "_mentions": 4, "_devurl": "https://github.com/tidyverse/dbplyr", "_pkgdown": "https://dbplyr.tidyverse.org/", "_searchresults": 6992, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dbplyr.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/tidyverse/dbplyr", "_realowner": "tidyverse", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2017-06-09" }, { "version": "1.1.0", "date": "2017-06-27" }, { "version": "1.2.0", "date": "2018-01-03" }, { "version": "1.2.1", "date": "2018-02-19" }, { "version": "1.2.2", "date": "2018-07-25" }, { "version": "1.3.0", "date": "2019-01-09" }, { "version": "1.4.0", "date": "2019-04-23" }, { "version": "1.4.1", "date": "2019-06-06" }, { "version": "1.4.2", "date": "2019-06-17" }, { "version": "1.4.3", "date": "2020-04-19" }, { "version": "1.4.4", "date": "2020-05-27" }, { "version": "2.0.0", "date": "2020-11-03" }, { "version": "2.1.0", "date": "2021-02-03" }, { "version": "2.1.1", "date": "2021-04-06" }, { "version": "2.2.0", "date": "2022-06-05" }, { "version": "2.2.1", "date": "2022-06-27" }, { "version": "2.3.0", "date": "2023-01-16" }, { "version": "2.3.1", "date": "2023-02-24" }, { "version": "2.3.2", "date": "2023-03-21" }, { "version": "2.3.3", "date": "2023-07-07" }, { "version": "2.3.4", "date": "2023-09-26" }, { "version": "2.4.0", "date": "2023-10-26" }, { "version": "2.5.0", "date": "2024-03-19" }, { "version": "2.5.1", "date": "2025-09-10" }, { "version": "2.5.2", "date": "2026-02-16" } ], "_exports": [ ".sql", "as_table_path", "as.sql", "base_agg", "base_no_win", "base_odbc_agg", "base_odbc_scalar", "base_odbc_win", "base_scalar", "base_win", "bind_queries", "build_sql", "check_table_path", "copy_inline", "copy_lahman", "copy_nycflights13", "db_col_types", "db_collect", "db_compute", "db_connection_describe", "db_copy_to", "db_sql_render", "db_table_drop_if_exists", "dbplyr_edition", "dbplyr_pivot_wider_spec", "dbplyr_uncount", "dialect_access", "dialect_ansi", "dialect_db2", "dialect_hana", "dialect_hive", "dialect_impala", "dialect_mariadb", "dialect_mssql", "dialect_mysql", "dialect_odbc", "dialect_oracle", "dialect_postgres", "dialect_redshift", "dialect_snowflake", "dialect_spark_sql", "dialect_sqlite", "dialect_teradata", "escape", "escape_ansi", "get_returned_rows", "has_lahman", "has_nycflights13", "has_returned_rows", "ident", "ident_q", "in_catalog", "in_schema", "is_table_path", "is.ident", "is.sql", "lahman_mysql", "lahman_postgres", "lahman_sqlite", "lahman_srcs", "last_sql", "lazy_base_query", "lazy_frame", "lazy_multi_join_query", "lazy_query", "lazy_rf_join_query", "lazy_select_query", "lazy_semi_join_query", "lazy_set_op_query", "lazy_union_query", "local_memdb_frame", "memdb", "memdb_frame", "named_commas", "new_sql_dialect", "nycflights13_postgres", "nycflights13_sqlite", "op_frame", "op_grps", "op_sort", "op_vars", "partial_eval", "remote_con", "remote_name", "remote_query", "remote_query_plan", "remote_src", "remote_table", "rf_join_query", "select_query", "semi_join_query", "set_op_query", "simulate_access", "simulate_dbi", "simulate_hana", "simulate_hive", "simulate_impala", "simulate_mariadb", "simulate_mssql", "simulate_mysql", "simulate_odbc", "simulate_oracle", "simulate_postgres", "simulate_redshift", "simulate_snowflake", "simulate_spark_sql", "simulate_sqlite", "simulate_teradata", "sql", "sql_aggregate", "sql_aggregate_2", "sql_aggregate_n", "sql_build", "sql_call2", "sql_cast", "sql_check_na_rm", "sql_cot", "sql_dialect", "sql_escape_date", "sql_escape_datetime", "sql_escape_ident", "sql_escape_logical", "sql_escape_raw", "sql_escape_string", "sql_expr", "sql_expr_matches", "sql_glue", "sql_glue2", "sql_indent_subquery", "sql_infix", "sql_join_suffix", "sql_log", "sql_not_supported", "sql_optimise", "sql_options", "sql_paste", "sql_paste_infix", "sql_prefix", "sql_query_append", "sql_query_delete", "sql_query_explain", "sql_query_fields", "sql_query_insert", "sql_query_join", "sql_query_multi_join", "sql_query_rows", "sql_query_save", "sql_query_select", "sql_query_semi_join", "sql_query_set_op", "sql_query_union", "sql_query_update_from", "sql_query_upsert", "sql_query_wrap", "sql_quote", "sql_random", "sql_render", "sql_returning_cols", "sql_runif", "sql_set_op_method", "sql_str_sub", "sql_substr", "sql_table_analyze", "sql_table_index", "sql_table_temporary", "sql_translation", "sql_translator", "sql_try_cast", "sql_variant", "sql_vector", "src_dbi", "src_memdb", "src_sql", "table_path_components", "table_path_name", "tbl_lazy", "tbl_memdb", "tbl_sql", "translate_sql", "translate_sql_", "union_query", "win_absent", "win_aggregate", "win_aggregate_2", "win_cumulative", "win_current_frame", "win_current_group", "win_current_order", "win_over", "win_rank", "win_recycled", "window_frame", "window_order", "with_dialect" ], "_help": [ { "page": "dot-sql", "title": "Flag SQL function usage", "topics": [ ".sql" ] }, { "page": "arrange.tbl_lazy", "title": "Arrange rows by column values", "topics": [ "arrange.tbl_lazy" ] }, { "page": "backend-access", "title": "MS Access backend", "topics": [ "dialect_access", "simulate_access" ] }, { "page": "backend-adbc", "title": "ADBC backend", "topics": [ "backend-adbc" ] }, { "page": "backend-ansi", "title": "ANSI SQL backend", "topics": [ "dialect_ansi", "simulate_dbi" ] }, { "page": "backend-db2", "title": "DB2 backend", "topics": [ "dialect_db2" ] }, { "page": "backend-hana", "title": "SAP HANA backend", "topics": [ "dialect_hana", "simulate_hana" ] }, { "page": "backend-hive", "title": "Hive backend", "topics": [ "dialect_hive", "simulate_hive" ] }, { "page": "backend-impala", "title": "Impala backend", "topics": [ "dialect_impala", "simulate_impala" ] }, { "page": "backend-jdbc", "title": "JDBC backend", "topics": [ "backend-jdbc" ] }, { "page": "backend-mssql", "title": "SQL Server backend", "topics": [ "dialect_mssql", "simulate_mssql" ] }, { "page": "backend-mysql", "title": "MySQL/MariaDB backend", "topics": [ "dialect_mariadb", "dialect_mysql", "simulate_mariadb", "simulate_mysql" ] }, { "page": "backend-odbc", "title": "ODBC backend", "topics": [ "dialect_odbc", "simulate_odbc" ] }, { "page": "backend-oracle", "title": "Oracle backend", "topics": [ "dialect_oracle", "simulate_oracle" ] }, { "page": "backend-postgres", "title": "PostgreSQL backend", "topics": [ "dialect_postgres", "simulate_postgres" ] }, { "page": "backend-redshift", "title": "Redshift backend", "topics": [ "dialect_redshift", "simulate_redshift" ] }, { "page": "backend-snowflake", "title": "Snowflake backend", "topics": [ "dialect_snowflake", "simulate_snowflake" ] }, { "page": "backend-spark-sql", "title": "Databricks Spark SQL backend", "topics": [ "dialect_spark_sql", "simulate_spark_sql" ] }, { "page": "backend-sqlite", "title": "SQLite backend", "topics": [ "dialect_sqlite", "simulate_sqlite" ] }, { "page": "backend-teradata", "title": "Teradata backend", "topics": [ "dialect_teradata", "simulate_teradata" ] }, { "page": "bind_queries", "title": "Combine multiple lazy queries", "topics": [ "bind_queries" ] }, { "page": "collapse.tbl_sql", "title": "Collapse a query into a subquery", "topics": [ "collapse.tbl_sql" ] }, { "page": "collect.tbl_sql", "title": "Collect results into a local data frame", "topics": [ "collect.tbl_sql" ] }, { "page": "complete.tbl_lazy", "title": "Complete a SQL table with missing combinations of data", "topics": [ "complete.tbl_lazy" ] }, { "page": "compute.tbl_sql", "title": "Save results into a new remote table", "topics": [ "compute.tbl_sql" ] }, { "page": "copy_inline", "title": "Use a local data frame in a dbplyr query", "topics": [ "copy_inline" ] }, { "page": "copy_to.src_sql", "title": "Copy a local data frame to a remote database", "topics": [ "copy_to.src_sql" ] }, { "page": "count.tbl_lazy", "title": "Count observations by group", "topics": [ "add_count.tbl_lazy", "count.tbl_lazy", "tally.tbl_lazy" ] }, { "page": "dbplyr_uncount", "title": "\"Uncount\" a database table", "topics": [ "dbplyr_uncount" ] }, { "page": "dbplyr-slice", "title": "Subset rows using their positions", "topics": [ "slice_max.tbl_lazy", "slice_min.tbl_lazy", "slice_sample.tbl_lazy" ] }, { "page": "distinct.tbl_lazy", "title": "Subset distinct/unique rows", "topics": [ "distinct.tbl_lazy" ] }, { "page": "do.tbl_sql", "title": "Perform arbitrary computation on remote backend", "topics": [ "do.tbl_sql" ] }, { "page": "escape", "title": "Escape/quote a value", "concept": [ "generic" ], "topics": [ "db-quote", "escape", "sql_escape_date", "sql_escape_datetime", "sql_escape_ident", "sql_escape_logical", "sql_escape_raw", "sql_escape_string", "sql_vector" ] }, { "page": "expand.tbl_lazy", "title": "Expand SQL tables to include all possible combinations of values", "topics": [ "expand.tbl_lazy" ] }, { "page": "fill.tbl_lazy", "title": "Fill in missing values with previous or next value", "topics": [ "fill.tbl_lazy" ] }, { "page": "filter.tbl_lazy", "title": "Keep or drop rows that match a condition", "topics": [ "filter.tbl_lazy", "filter_out.tbl_lazy" ] }, { "page": "get_returned_rows", "title": "Extract and check the 'RETURNING' rows", "topics": [ "get_returned_rows", "has_returned_rows" ] }, { "page": "group_by.tbl_lazy", "title": "Group by one or more variables", "topics": [ "group_by.tbl_lazy" ] }, { "page": "head.tbl_lazy", "title": "Subset the first rows", "topics": [ "head.tbl_lazy" ] }, { "page": "intersect.tbl_lazy", "title": "SQL set operations", "topics": [ "intersect.tbl_lazy", "setdiff.tbl_lazy", "union.tbl_lazy", "union_all.tbl_lazy" ] }, { "page": "join.tbl_sql", "title": "Join SQL tables", "topics": [ "anti_join.tbl_lazy", "cross_join.tbl_lazy", "full_join.tbl_lazy", "inner_join.tbl_lazy", "join.tbl_sql", "left_join.tbl_lazy", "right_join.tbl_lazy", "semi_join.tbl_lazy" ] }, { "page": "last_sql", "title": "Retrieve the last SQL query generated", "topics": [ "last_sql" ] }, { "page": "memdb", "title": "A temporary in-memory database", "topics": [ "local_memdb_frame", "memdb", "memdb_frame" ] }, { "page": "mutate.tbl_lazy", "title": "Create, modify, and delete columns", "topics": [ "mutate.tbl_lazy" ] }, { "page": "pivot_longer.tbl_lazy", "title": "Pivot data from wide to long", "topics": [ "pivot_longer.tbl_lazy" ] }, { "page": "pivot_wider.tbl_lazy", "title": "Pivot data from long to wide", "topics": [ "dbplyr_pivot_wider_spec", "pivot_wider.tbl_lazy" ] }, { "page": "pull.tbl_sql", "title": "Extract a single column", "topics": [ "pull.tbl_sql" ] }, { "page": "remote_name", "title": "Metadata about a remote table", "topics": [ "remote_con", "remote_name", "remote_query", "remote_query_plan", "remote_src", "remote_table" ] }, { "page": "replace_na.tbl_lazy", "title": "Replace NAs with specified values", "topics": [ "replace_na.tbl_lazy" ] }, { "page": "rows-db", "title": "Edit individual rows in the underlying database table", "topics": [ "rows_append.tbl_lazy", "rows_delete.tbl_lazy", "rows_insert.tbl_lazy", "rows_patch.tbl_lazy", "rows_update.tbl_lazy", "rows_upsert.tbl_lazy" ] }, { "page": "select.tbl_lazy", "title": "Subset, rename, and reorder columns using their names", "topics": [ "relocate.tbl_lazy", "rename.tbl_lazy", "rename_with.tbl_lazy", "select.tbl_lazy" ] }, { "page": "show_query", "title": "Show generated SQL and query plan", "topics": [ "explain.tbl_sql", "show_query", "show_query.tbl_lazy" ] }, { "page": "sql", "title": "Literal SQL escaping", "topics": [ "is.sql", "sql" ] }, { "page": "sql_dialect", "title": "SQL dialects", "topics": [ "new_sql_dialect", "sql_dialect" ] }, { "page": "sql_glue", "title": "Build SQL strings with glue syntax", "topics": [ "sql_glue", "sql_glue2" ] }, { "page": "sql_options", "title": "Options for generating SQL", "topics": [ "sql_options" ] }, { "page": "sql_query_insert", "title": "Generate SQL for Insert, Update, Upsert, and Delete", "topics": [ "sql_query_append", "sql_query_delete", "sql_query_insert", "sql_query_update_from", "sql_query_upsert" ] }, { "page": "sql_translation_agg", "title": "SQL helpers for aggregate functions", "concept": [ "SQL translation helpers" ], "topics": [ "sql_aggregate", "sql_aggregate_2", "sql_aggregate_n", "sql_check_na_rm", "sql_not_supported", "sql_translation_agg" ] }, { "page": "sql_translation_scalar", "title": "SQL helpers for scalar functions", "concept": [ "SQL translation helpers" ], "topics": [ "sql_cast", "sql_cot", "sql_infix", "sql_log", "sql_prefix", "sql_runif", "sql_translation_scalar", "sql_try_cast" ] }, { "page": "sql_translation_string", "title": "SQL helpers for string functions", "concept": [ "SQL translation helpers" ], "topics": [ "sql_paste", "sql_paste_infix", "sql_str_sub", "sql_substr", "sql_translation_string" ] }, { "page": "sql_translation_window", "title": "SQL helpers for window functions", "concept": [ "SQL translation helpers" ], "topics": [ "sql_translation_window", "win_absent", "win_aggregate", "win_aggregate_2", "win_cumulative", "win_current_frame", "win_current_group", "win_current_order", "win_over", "win_rank", "win_recycled" ] }, { "page": "sql_variant", "title": "Create an SQL translator", "concept": [ "SQL translation helpers" ], "topics": [ "base_agg", "base_no_win", "base_odbc_agg", "base_odbc_scalar", "base_odbc_win", "base_scalar", "base_win", "sql_translator", "sql_variant" ] }, { "page": "summarise.tbl_lazy", "title": "Summarise each group to one row", "topics": [ "summarise.tbl_lazy" ] }, { "page": "tbl.src_dbi", "title": "Create a lazy query backed by a database", "topics": [ "tbl.src_dbi", "tbl_dbi" ] }, { "page": "translate_sql", "title": "Translate an expression to SQL", "topics": [ "translate_sql", "translate_sql_" ] }, { "page": "window_order", "title": "Override window order and frame", "topics": [ "window_frame", "window_order" ] }, { "page": "with_dialect", "title": "Override the SQL dialect for a connection", "topics": [ "with_dialect" ] } ], "_pkglogo": "https://github.com/tidyverse/dbplyr/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/tidyverse/dbplyr/raw/HEAD/README.md", "_rundeps": [ "blob", "cli", "cpp11", "DBI", "dplyr", "generics", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "purrr", "R6", "rlang", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "new-backend.Rmd", "filename": "new-backend.html", "title": "Developing a dbplyr backend", "engine": "knitr::rmarkdown", "headings": [ "First steps", "Write your first method", "Define a dialect", "Copying, computing, collecting and collapsing", "SQL translation: verbs", "Building SQL strings", "Behind the scenes", "SQL translation: vectors", "Scalar function helpers", "Aggregation function helpers", "Window function helpers", "Custom translation functions" ], "created": "2017-04-02 10:41:34", "modified": "2026-01-14 13:51:46", "commits": 24 }, { "source": "translation-function.Rmd", "filename": "translation-function.html", "title": "Function translation", "engine": "knitr::rmarkdown", "headings": [ "Getting started with translations", "Basic differences", "Known functions", "Mathematics", "Modulo arithmetic", "Logical comparisons and boolean operations", "Bitwise operations", "Type coercion", "NULL/NA handling", "Aggregation", "Conditional evaluation", "String functions", "Date/time functions", "Other functions", "Unknown functions", "Prefix functions", "Infix functions", "Special forms", "Error for unknown translations", "Window functions" ], "created": "2019-01-10 15:35:50", "modified": "2026-01-05 21:48:25", "commits": 26 }, { "source": "dbplyr.Rmd", "filename": "dbplyr.html", "title": "Introduction to dbplyr", "engine": "knitr::rmarkdown", "headings": [ "Getting started", "Connecting to the database", "Generating queries", "Why use dbplyr?", "What happens when dbplyr fails?", "Creating your own database", "MySQL/MariaDB", "PostgreSQL", "BigQuery" ], "created": "2017-04-02 10:41:34", "modified": "2025-12-15 14:43:14", "commits": 26 }, { "source": "reprex.Rmd", "filename": "reprex.html", "title": "Reprexes for dbplyr", "engine": "knitr::rmarkdown", "headings": [ "Using memdb_frame()", "Translating verbs", "Translating individual expressions" ], "created": "2019-02-05 15:49:18", "modified": "2025-12-18 17:06:59", "commits": 6 }, { "source": "translation-verb.Rmd", "filename": "translation-verb.html", "title": "Verb translation", "engine": "knitr::rmarkdown", "headings": [ "Single table verbs", "Subqueries", "Dual table verbs" ], "created": "2019-01-10 15:35:50", "modified": "2025-12-22 22:07:41", "commits": 12 } ], "_score": 19.854604316561463, "_indexed": true, "_nocasepkg": "dbplyr", "_universes": [ "tidyverse", "hadley" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "2.5.2.9000", "date": "2026-05-24T06:53:35.000Z", "distro": "noble", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "88d9b664ab6084d877ac3bc11b5f029dceabe466890787d24cd8f0cf2bcfca6f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" }, { "r": "4.6.0", "os": "linux", "version": "2.5.2.9000", "date": "2026-05-24T06:53:40.000Z", "distro": "noble", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "2c2271dc58ca1ba9a24e8e8bb19dac5dbbf5fdd7644e3fa1c406bea6f8eb06ab", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" }, { "r": "4.5.3", "os": "mac", "version": "2.5.2.9000", "date": "2026-05-24T07:25:12.000Z", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "36f991155516fe134a623db9a5be51e735d974c38421a6793575fb3a67682a3a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" }, { "r": "4.6.0", "os": "mac", "version": "2.5.2.9000", "date": "2026-05-24T07:24:09.000Z", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "aa87ef0f4deaadaa571551a0219aac6e4d9248b8150014b869b2c5aa179456f9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" }, { "r": "4.6.0", "os": "wasm", "version": "2.5.2.9000", "date": "2026-05-24T06:53:29.000Z", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "7ae6db0e28241bfa482086f4784a3065daaea8fce0ed65e5680efa5defdcf3ff", "status": "success", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" }, { "r": "4.7.0", "os": "win", "version": "2.5.2.9000", "date": "2026-05-24T06:52:38.000Z", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "0fbf19fd1ab82fd6ee2a17a5f0e2064a667d8d9aaeea9e98abc872ce9120a5ec", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" }, { "r": "4.5.3", "os": "win", "version": "2.5.2.9000", "date": "2026-05-24T06:52:35.000Z", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "77471a2d22e2c319aee72d84309da45575792a8c81f8b069d23f5f31dd0c4a1d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" }, { "r": "4.6.0", "os": "win", "version": "2.5.2.9000", "date": "2026-05-24T06:54:41.000Z", "commit": "f52aaa9627096262e692d3c4974a29669c855095", "fileid": "68f8da381ffc06ed703e6761ce3d8c75dc1b005ac7fa09941ab98a7c80890382", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/tidyverse/actions/runs/26354363776" } ] }