{
  "_id": "6ad469ad104c877e3b413fa5",
  "Package": "sqlparseR",
  "Type": "Package",
  "Title": "Wrapper for 'Python' Module 'sqlparse': Parse, Split, and Format\n'SQL'",
  "Version": "0.1.0",
  "Authors@R": "person(\"Michael\", \"Simmler\", email = \"michael.simmler@agroscope.admin.ch\", role = c(\"aut\", \"cre\"))",
  "Description": "Wrapper for the non-validating 'SQL' parser 'Python'\nmodule 'sqlparse' <https://github.com/andialbrecht/sqlparse>.\nIt allows parsing, splitting, and formatting 'SQL' statements.",
  "License": "GPL-3",
  "Encoding": "UTF-8",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-18 06:29:19 UTC",
    "User": "root"
  },
  "Author": "Michael Simmler [aut, cre]",
  "Maintainer": "Michael Simmler <michael.simmler@agroscope.admin.ch>",
  "Config/pak/sysreqs": "libpng-dev python3",
  "Repository": "https://agroscope-ch.r-universe.dev",
  "Date/Publication": "2023-11-24 16:03:58 UTC",
  "RemoteUrl": "https://github.com/agroscope-ch/sqlparser",
  "RemoteRef": "HEAD",
  "RemoteSha": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
  "_user": "agroscope-ch",
  "_type": "src",
  "_file": "sqlparseR_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/8d04b73d89b384cabd8349780bb954cd22b0311a877ad8c9ad394f9afb90a1b0",
  "_filesize": 102604,
  "_sha256": "8d04b73d89b384cabd8349780bb954cd22b0311a877ad8c9ad394f9afb90a1b0",
  "_expires": "2027-01-26T06:39:39.000Z",
  "_created": "2026-10-18T06:29:19.000Z",
  "_published": "2026-10-18T06:39:41.085Z",
  "_buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 117606540494,
      "time": 111,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12127603837"
    },
    {
      "job": 117606540445,
      "time": 137,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12127263302"
    },
    {
      "job": 117606540471,
      "time": 177,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12127124259"
    },
    {
      "job": 117606540436,
      "time": 96,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12128385291"
    },
    {
      "job": 117606128349,
      "time": 142,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12127103530"
    },
    {
      "job": 117606540397,
      "time": 81,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "12127073726"
    },
    {
      "job": 117606540451,
      "time": 124,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "12128320082"
    },
    {
      "job": 117606540481,
      "time": 123,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "12126769765"
    },
    {
      "job": 117606540433,
      "time": 126,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "12127991045"
    }
  ],
  "_upstream": "https://github.com/agroscope-ch/sqlparser",
  "_commit": {
    "id": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
    "author": "AgroSimi <48689093+AgroSimi@users.noreply.github.com>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Update README.md",
    "time": 1700841838
  },
  "_maintainer": {
    "name": "Michael Simmler",
    "email": "michael.simmler@agroscope.admin.ch",
    "login": "michaelsimmler",
    "description": "",
    "uuid": 48689093
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "reticulate",
      "version": ">= 1.13",
      "role": "Imports"
    }
  ],
  "_owner": "agroscope-ch",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "michaelsimmler",
      "count": 4,
      "uuid": 48689093
    }
  ],
  "_userbio": {
    "uuid": 95276560,
    "type": "organization",
    "name": "Agroscope",
    "followers": 25,
    "description": "Agroscope is the Swiss centre of excellence for agricultural research"
  },
  "_downloads": {
    "count": 246,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlparseR"
  },
  "_devurl": "https://github.com/agroscope-ch/sqlparser",
  "_searchresults": 4,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/sqlparseR.html"
  ],
  "_realowner": "michaelsimmler",
  "_cranurl": false,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2019-09-20"
    }
  ],
  "_exports": [
    "install_sqlparse_py",
    "sql_format",
    "sql_parse",
    "sql_split"
  ],
  "_help": [
    {
      "page": "install_sqlparse_py",
      "title": "Install sqlparse Python package",
      "topics": [
        "install_sqlparse_py"
      ]
    },
    {
      "page": "sql_format",
      "title": "Format SQL Statements",
      "topics": [
        "sql_format"
      ]
    },
    {
      "page": "sql_parse",
      "title": "Parse SQL Statements",
      "topics": [
        "sql_parse"
      ]
    },
    {
      "page": "sql_split",
      "title": "Split SQL to Single Statements",
      "topics": [
        "sql_split"
      ]
    }
  ],
  "_readme": "https://github.com/agroscope-ch/sqlparser/raw/HEAD/README.md",
  "_rundeps": [
    "here",
    "jsonlite",
    "lattice",
    "Matrix",
    "png",
    "rappdirs",
    "Rcpp",
    "RcppTOML",
    "reticulate",
    "rlang",
    "rprojroot",
    "withr"
  ],
  "_score": 1.6989700043360187,
  "_indexed": false,
  "_nocasepkg": "sqlparser",
  "_universes": [
    "agroscope-ch"
  ],
  "_indexurl": "https://michaelsimmler.r-universe.dev/sqlparseR",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-18T06:31:01.000Z",
      "distro": "resolute",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/800678a73254dddb6f60859d55f74114944eb526b640889166def7745ba6ca55",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-10-18T06:31:26.000Z",
      "distro": "resolute",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/c9e02c45a12ed32c20792aabada1e3ee36a2311b113f79f75e40863ed54a8b70",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-18T06:38:20.000Z",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/b70c8816bf87ff649831de74e47a688404599b865f3b0b5deff9e4d096970a50",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-10-18T06:36:45.000Z",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/2b8bb976fc8799297fd27b06dd42cd335cc808752d617e62554b5dac67db1f33",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-10-18T06:30:59.000Z",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/bf5afc1ba0023f22f9957e197036723dd02509c5915bd48a474cb6e20e3a7958",
      "status": "success",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-18T06:30:27.000Z",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/d332e855c7604eae5783642c420f1ab5150c9dfa8a0d607f6a8d5b7043aa62be",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-18T06:30:25.000Z",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/0d0bac4fd0ebe80eb88d58936e36f31db411708b7dfa59bf3d99652be818c25a",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-10-18T06:30:30.000Z",
      "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884",
      "fileid": "https://r2.ropensci.org/7e8d5a966ab5b6416b4b95f6e83818780a6f61bb3990fe08ff405e50a3093033",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/39104059118"
    }
  ]
}