The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

Introduction to RSqlParser

Subhasree Bose

2020-05-11

RSqlParser is a non-validating sql paser. It can be used to get various components of sql statements.

library(RSqlParser)

Methods

There are currently 4 methods in the package:

get_all_bind_variables: Get the bind variables in sql.
get_all_select_cols_with_alias: Get the names of the selected columns in the sql
get_all_subqueries: Get the subqueries in sql.
get_all_tables_with_alias:  Get the names of the tables with alias present in the sql

Note

This is a non-validating module. It expects syntactically correct sql statements.

Currently, it supports only SELECT statements.

get_all_subqueries does not return nested sub queries. To retreive nested subquery, the subquery of the main select query needs to be passed in this method again.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.