{
  "_id": "6a1d526d1d7bb097a0a45fdb",
  "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-06-01 09:33:06 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",
  "MD5sum": "a3f5e04dc99c465bb5142211b5ed288f",
  "_user": "cran",
  "_type": "src",
  "_file": "SQL_0.1.1.tar.gz",
  "_fileid": "ebf1eb6b402ea0ea6a4832ed285d8a8326f6174f7774635b0ac93ecedc0861bc",
  "_filesize": 75886,
  "_sha256": "ebf1eb6b402ea0ea6a4832ed285d8a8326f6174f7774635b0ac93ecedc0861bc",
  "_created": "2026-06-01T09:33:06.000Z",
  "_published": "2026-06-01T09:35:41.882Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78824497813,
      "time": 115,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7328067110"
    },
    {
      "job": 78824497728,
      "time": 109,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7328065271"
    },
    {
      "job": 78824055499,
      "time": 164,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7328029131"
    },
    {
      "job": 78824497748,
      "time": 104,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7328064018"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/26746558801",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_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"
  },
  "_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",
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 223,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQL"
  },
  "_searchresults": 13,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/SQL.html",
    "manual.pdf"
  ],
  "_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.1139433523068367,
  "_indexed": true,
  "_nocasepkg": "sql",
  "_universes": [
    "cran"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.1",
      "date": "2026-06-01T09:35:04.000Z",
      "distro": "noble",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "73be20fca5a19248798cf901fd6034df4951951c62f842f7825e5eeaec7449cb",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/26746558801"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.1",
      "date": "2026-06-01T09:34:56.000Z",
      "distro": "noble",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "51213185643a75fdf81e6180a168e1bf2aa13bd6cf3f688285eba995555d0d25",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/26746558801"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.1",
      "date": "2026-06-01T09:35:12.000Z",
      "commit": "231a28d07280c97d9edb6d941799011a6da2d30b",
      "fileid": "0dd93f72e37449148f9a5b9ca2c460be60f6e7b5485259ae02db66e2588d50fc",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/26746558801"
    }
  ]
}