The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
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[@]dogado.de.

queryparser 0.3.2

• Throws an error if called from an incompatible version of tidyquery (#32)
• Minor bugfixes and improvements

queryparser 0.3.1

• Queries can contain multibyte characters (#21)
• Queries can have no whitespace around keywords (#27)
• substring_index() translates when tidyverse = TRUE (#29)
• embedded nuls warnings are silenced (#30)
• Syntactically invalid column names are allowed in backticks (#31)
• Minor bugfixes and improvements

queryparser 0.3.0

• ORDER BY clause can include NULLS FIRST and NULLS LAST (#12, @StevenHibble)
• Translations of expressions in the ORDER BY clause now use -xtfrm() instead of the attribute decreasing to indicate descending order (@StevenHibble)
• Parentheses can enclose table names and joins in the FROM clause (#23)
• More Microsoft SQL Server functions now translate (#26, @StevenHibble)
• Minor bugfixes and improvements

queryparser 0.2.0

• BETWEEN expressions with quotes in operands translate correctly (#13)
• Line comments (--) and block comments (/* */) are removed from queries (#14)
• coalesce() translates correctly when tidyverse = FALSE (#15, #17)
• CASE expressions translate (#16, #18)
• Table aliases can be used in queries (#19)
• SQL-92-style (explicit) join queries translate (#20)
• Continuous integration and coverage tests
• Minor bugfixes and improvements

queryparser 0.1.1

• Output indicates when queries aggregate
  • List returned by parse_query() has attribute aggregate set to TRUE if query aggregates (#8)
  • When translating an aggregate query, sublist select returned by by parse_query() has logical vector attribute aggregate indicating whether each expression in the SELECT list aggregates (#9)
  • When translating an aggregate query with an ORDER BY clause, sublist order_by returned by by parse_query() has logical vector attribute aggregate indicating whether each expression in the ORDER BY clause aggregates (#11)
• Translation of multiple CAST and BETWEEN expressions in a single expression no longer fails (#10)
• Minor bugfixes and improvements

queryparser 0.1.0

• First CRAN release
• Column names that match SQL function names are not converted to lowercase (#1)
• Outputted expressions use vectorized logical operators (#2)
• Successive occurrences of binary symbolic operators are replaced (#3)
• Column names that match function names are not replaced (#4)
• Vulnerabilities that permitted use of disallowed functions are resolved (#5, #7)
• Column names can contain periods (#6)

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.
Health stats visible at Monitor.