{
  "_id": "6a104468acfb0bcc41c9e406",
  "Package": "RSqlParser",
  "Type": "Package",
  "Title": "Parse 'SQL' Statements",
  "Version": "1.5",
  "Author": "Subhasree Bose",
  "Maintainer": "Subhasree Bose <subhasree10.7@gmail.com>",
  "Description": "Parser for 'SQL' statements. Currently, it supports\nparsing of only 'SELECT' statements.",
  "License": "GPL-2",
  "Encoding": "UTF-8",
  "RoxygenNote": "7.1.0",
  "VignetteBuilder": "knitr",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-11 06:33:24 UTC",
    "User": "root"
  },
  "Repository": "https://cran.r-universe.dev",
  "Date/Publication": "2020-05-14 07:40:06 UTC",
  "RemoteUrl": "https://github.com/cran/RSqlParser",
  "RemoteRef": "HEAD",
  "RemoteSha": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
  "MD5sum": "cf13ea58af8a18b6dd62f4e5809d0327",
  "_user": "cran",
  "_type": "src",
  "_file": "RSqlParser_1.5.tar.gz",
  "_fileid": "55abcccc9fe73a800bb4036c19c95a4d983143bd599c96d2ed22b9aa6c3597dd",
  "_filesize": 79821,
  "_sha256": "55abcccc9fe73a800bb4036c19c95a4d983143bd599c96d2ed22b9aa6c3597dd",
  "_created": "2026-05-11T06:33:24.000Z",
  "_published": "2026-05-22T11:56:24.365Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77374497965,
      "time": 112,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6911776353"
    },
    {
      "job": 77374497901,
      "time": 113,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6911776255"
    },
    {
      "job": 77374497236,
      "time": 170,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6911748771"
    },
    {
      "job": 77374497275,
      "time": 127,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7159885127"
    }
  ],
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/25654143251",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/cran/RSqlParser",
  "_commit": {
    "id": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
    "author": "Subhasree Bose <subhasree10.7@gmail.com>",
    "committer": "cran-robot <csardi.gabor+cran@gmail.com>",
    "message": "version 1.5\n",
    "time": 1589442006
  },
  "_maintainer": {
    "name": "Subhasree Bose",
    "email": "subhasree10.7@gmail.com"
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 2.1.0",
      "role": "Depends"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "stringi",
      "role": "Imports"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    }
  ],
  "_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": 196,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RSqlParser"
  },
  "_searchresults": 4,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/RSqlParser.html",
    "manual.pdf"
  ],
  "_realowner": "cran",
  "_cranurl": false,
  "_releases": [
    {
      "version": "1.5",
      "date": "2020-05-14"
    }
  ],
  "_exports": [
    "get_all_bind_variables",
    "get_all_select_cols_with_alias",
    "get_all_subqueries",
    "get_all_tables_with_alias"
  ],
  "_help": [
    {
      "page": "get_all_bind_variables",
      "title": "Get the bind variables in sql statement",
      "topics": [
        "get_all_bind_variables"
      ]
    },
    {
      "page": "get_all_select_cols_with_alias",
      "title": "Get the names of the selected columns in the sql statement",
      "topics": [
        "get_all_select_cols_with_alias"
      ]
    },
    {
      "page": "get_all_subqueries",
      "title": "Get the subqueries in sql statement",
      "topics": [
        "get_all_subqueries"
      ]
    },
    {
      "page": "get_all_tables_with_alias",
      "title": "Get the names of the tables with alias present in the sql",
      "topics": [
        "get_all_tables_with_alias"
      ]
    }
  ],
  "_rundeps": [
    "cli",
    "glue",
    "lifecycle",
    "magrittr",
    "rlang",
    "stringi",
    "stringr",
    "vctrs"
  ],
  "_vignettes": [
    {
      "source": "introduction.Rmd",
      "filename": "introduction.html",
      "title": "Introduction to RSqlParser",
      "author": "Subhasree Bose",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Methods",
        "Note"
      ],
      "created": "2020-05-14 07:40:06",
      "modified": "2020-05-14 07:40:06",
      "commits": 1
    }
  ],
  "_score": 2,
  "_indexed": true,
  "_nocasepkg": "rsqlparser",
  "_universes": [
    "cran"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.5",
      "date": "2026-05-11T06:35:26.000Z",
      "distro": "noble",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "242ec88d0d00eca9f7096317fb335494534f0ba74d34fa2b0e680eb34236cf38",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25654143251"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "1.5",
      "date": "2026-05-11T06:35:25.000Z",
      "distro": "noble",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "2389083ecd26dbfb20928e132fe87f26ca6e80e77c6c29447f8176e45ff2286b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25654143251"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.5",
      "date": "2026-05-22T11:56:08.000Z",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "040585759e9b1b4bcb02ee3b9afb739e0c2e1d18e561f5c7e094969566387300",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/25654143251"
    }
  ]
}