sql-surveyor

High-level SQL parser. Identify tables, columns, aliases and more from your SQL script in one easy to consume object. Supports PostgreSQL, MySQL, SQL Server and Oracle (PL/SQL) dialects.

MIT License

Downloads
61
Stars
27
Committers
3

Bot releases are hidden (Show)

sql-surveyor - 1.4.1 Latest Release

Published by mtriff over 3 years ago

  • Switch @ import to use relative path
  • Fix logging error during initial SQL parse when logging option is disabled
sql-surveyor - 1.5.0-alpha.0

Published by mtriff over 3 years ago

Initial implementation of:

  • Stored procedure execution parsing for PL/SQL
  • Control flow statement parsing for PL/SQL
sql-surveyor - 1.4.0

Published by mtriff over 3 years ago

  • Updated dependencies
    • Includes improved T-SQL, PL/SQL and PL/pgSQL parsing
sql-surveyor - 1.3.0

Published by mtriff over 3 years ago

  • Adds ability to control how errors are handled while surveying a SQL script. Optionally choose between logging errors or throwing errors (or neither). By default SQL Surveyor will throw errors. These options are specified during SQL Surveyor instance creation (second constructor argument).
  • Can now change the SQL dialect for a SQLSurveyor instance that has already been instantiated using the setDialect method.
sql-surveyor - 1.2.2

Published by mtriff almost 4 years ago

Fixes #2.

  • Fix handling of "tableName AS alias" syntax for PL/pgSQL
  • Improve handling of "tableName AS alias" syntax for MySQL
sql-surveyor - 1.2.1

Published by mtriff almost 4 years ago

  • Detect referenced columns within subqueries in a SELECT list
  • Fix aggregated output column detection in T-SQL
  • Fix table location identification inside aggregation functions for MySQL, PL/SQL, and PL/pgSQL
sql-surveyor - 1.2.0

Published by mtriff almost 4 years ago

  • Add type attribute to the Token class. Tokens are now identified as a comment, identifier, keyword, literal or operator.
sql-surveyor - 1.1.1

Published by mtriff almost 4 years ago

Fix column alias parsing for CASE statements

sql-surveyor - 1.1.0

Published by mtriff almost 4 years ago

  • Add support for column aliases in OutputColumns
  • Improve consistency when parsing table names or aliases from output columns
  • Attempt to finish parsing if an error occurs
  • Fix bug where attempting to retrieve a subquery at a location between two other subqueries (would return the next subquery)
sql-surveyor - 1.0.0

Published by mtriff almost 4 years ago