{
  "_id": "6ac4f0caf511ae58c09a34e8",
  "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-10-06 12:57:32 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",
  "_user": "cran",
  "_type": "src",
  "_file": "RSqlParser_1.5.tar.gz",
  "_fileid": "https://r2.ropensci.org/accf2879e9edbd8f3ec872e4c6e98fbb3ac5b3bd098e38f48dd2388b19fe191e",
  "_filesize": 79327,
  "_sha256": "accf2879e9edbd8f3ec872e4c6e98fbb3ac5b3bd098e38f48dd2388b19fe191e",
  "_expires": "2027-01-14T12:59:53.000Z",
  "_created": "2026-10-06T12:57:32.000Z",
  "_published": "2026-10-06T12:59:54.690Z",
  "_jobs": [
    {
      "job": 112280866586,
      "time": 102,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11415287062"
    },
    {
      "job": 112280866662,
      "time": 100,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11414807677"
    },
    {
      "job": 112279533942,
      "time": 179,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11415191616"
    },
    {
      "job": 112280866481,
      "time": 84,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11415126956"
    },
    {
      "job": 112280866910,
      "time": 78,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "11415656666"
    },
    {
      "job": 112280866601,
      "time": 63,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11414777098"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/cran/actions/runs/37466689706",
  "_status": "success",
  "_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"
  },
  "_distro": "resolute",
  "_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",
    "followers": 630,
    "description": "Unofficial read-only mirror of all CRAN R packages"
  },
  "_downloads": {
    "count": 278,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RSqlParser"
  },
  "_searchresults": 5,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/manual.pdf",
    "extra/RSqlParser.html"
  ],
  "_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-10-06T12:59:19.000Z",
      "distro": "resolute",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "https://r2.ropensci.org/118ce814b855a55af5dc12873102b0c145faa3f05de940c7e9b1f6a339e8193b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37466689706"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "1.5",
      "date": "2026-10-06T12:59:15.000Z",
      "distro": "resolute",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "https://r2.ropensci.org/387d16545f91aa81c3978743fd8502cff59af4f5f6ed2ae46f4d8f77728cee94",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37466689706"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.5",
      "date": "2026-10-06T12:59:14.000Z",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "https://r2.ropensci.org/894cfe2752854ea8d923b8f5e489784191155008cad6f6d42d6e7547ca53bd1a",
      "status": "success",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37466689706"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.5",
      "date": "2026-10-06T12:58:51.000Z",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "https://r2.ropensci.org/fe8519339b3aa8c9b350998ca421f106481e09597a845b156aff845601fa04d1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37466689706"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "1.5",
      "date": "2026-10-06T12:58:36.000Z",
      "commit": "deb481606a9ce449a8c9ed979194d72dcbc76f4c",
      "fileid": "https://r2.ropensci.org/0be8f92c9aa0ea90a62a39a96522fa4c4cd57ec21642a6840b84e1404f5b9f3d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/cran/actions/runs/37466689706"
    }
  ]
}