{
  "_id": "6ac0f6ae552a13804ac7e44b",
  "Package": "SQL",
  "Type": "Package",
  "Title": "Executes 'SQL' Statements",
  "Version": "0.1.1",
  "Authors@R": "c(\nperson(\"Jean-Luc\", \"Lipatz\", email = \"jllipatz@protonmail.com\", role = c(\"aut\", \"cre\", \"cph\")))",
  "Description": "Runs 'SQL' statements on in-memory data frames within a\ntemporary in-memory 'duckdb' data base.",
  "License": "GPL (>= 2)",
  "Encoding": "UTF-8",
  "ByteCompile": "yes",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-03 12:33:36 UTC",
    "User": "root"
  },
  "Author": "Jean-Luc Lipatz [aut, cre, cph]",
  "Maintainer": "Jean-Luc Lipatz <jllipatz@protonmail.com>",
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2023-05-25 08:20:13 UTC",
  "RemoteUrl": "https://github.com/cran/SQL",
  "RemoteRef": "HEAD",
  "RemoteSha": "231a28d07280c97d9edb6d941799011a6da2d30b",
  "_user": "cran",
  "_type": "src",
  "_file": "SQL_0.1.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/8a62ab027c6057c134853f82bfeaaac6b1cda822ee19b11629f8044878dbbc9a",
  "_filesize": 77076,
  "_sha256": "8a62ab027c6057c134853f82bfeaaac6b1cda822ee19b11629f8044878dbbc9a",
  "_expires": "2027-01-11T12:35:56.000Z",
  "_created": "2026-10-03T12:33:36.000Z",
  "_published": "2026-10-03T12:35:57.991Z",
  "_jobs": [
    {
      "job": 111203444935,
      "time": 96,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11274112720"
    },
    {
      "job": 111203444987,
      "time": 103,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11274446993"
    },
    {
      "job": 111202966109,
      "time": 190,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11274187411"
    },
    {
      "job": 111203444929,
      "time": 90,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11273883277"
    },
    {
      "job": 111203444968,
      "time": 63,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11273893187"
    },
    {
      "job": 111203444928,
      "time": 68,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11273613023"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/37123084122",
  "_status": "success",
  "_upstream": "https://github.com/cran/SQL",
  "_commit": {
    "id": "231a28d07280c97d9edb6d941799011a6da2d30b",
    "author": "Jean-Luc Lipatz <jllipatz@protonmail.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 0.1.1\n",
    "time": 1685002813
  },
  "_maintainer": {
    "name": "Jean-Luc Lipatz",
    "email": "jllipatz@protonmail.com"
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "duckdb",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    }
  ],
  "_owner": "cran",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_stars": 0,
  "_userbio": {
    "uuid": 6899542,
    "type": "organization",
    "name": "cran",
    "followers": 630,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 323,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQL"
  },
  "_searchresults": 23,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/SQL.html"
  ],
  "_realowner": "cran",
  "_cranurl": false,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2023-04-27"
    },
    {
      "version": "0.1.1",
      "date": "2023-05-25"
    }
  ],
  "_exports": [
    "SQL"
  ],
  "_help": [
    {
      "page": "SQL",
      "title": "Run duckdb SQL statements on data frames",
      "topics": [
        "SQL"
      ]
    }
  ],
  "_rundeps": [
    "arrow",
    "assertthat",
    "bit",
    "bit64",
    "cli",
    "cpp11",
    "DBI",
    "duckdb",
    "glue",
    "lifecycle",
    "magrittr",
    "purrr",
    "R6",
    "rlang",
    "stringi",
    "stringr",
    "tidyselect",
    "vctrs",
    "withr"
  ],
  "_score": 1.3617278360175928,
  "_indexed": true,
  "_nocasepkg": "sql",
  "_universes": [
    "cran"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.1",
      "date": "2026-10-03T12:35:19.000Z",
      "distro": "resolute",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "https://r2.ropensci.org/2b8ca21dc84f61bf35ec9b900d2144d7c29022b3b55b34af39a49aa2df7d3a63",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37123084122"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.1",
      "date": "2026-10-03T12:35:23.000Z",
      "distro": "resolute",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "https://r2.ropensci.org/4a63c89ba0cee0e271df34752c976a21a3491f399d9cda30960850021680b678",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37123084122"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.1",
      "date": "2026-10-03T12:35:24.000Z",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "https://r2.ropensci.org/a988636e64cadac13168feb80c0d1b5f91d2da1023cf48b2908cccb8a20bc96d",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37123084122"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.1",
      "date": "2026-10-03T12:34:35.000Z",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "https://r2.ropensci.org/c971c6348ab0ebc08f5d269fbf243921516e5646b060503d2bfbadfc3ff59c41",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37123084122"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.1",
      "date": "2026-10-03T12:34:40.000Z",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "https://r2.ropensci.org/7a546161dd9dc4e4d6d37f89ae01639fabb548d9746297993428fcea204f5141",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37123084122"
    }
  ]
}