Skip to content

Latest commit

 

History

History
51 lines (40 loc) · 4.06 KB

NEWS.md

File metadata and controls

51 lines (40 loc) · 4.06 KB
Raw

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)