SQL QUERY PARSING AND TRANSLATION

摘要

Various embodiments of systems and methods of translating SQL queries are described herein. A structured query language (SQL) query of a first database is split into tokens and traversed from a first token. When a keyword token is encountered, a current parser is created to store a table name and a column name associated with the encountered keyword token. When an open parenthesis is encountered, a token immediately preceding the open parenthesis is stored as a function name in the current parser. The table names, column names, and function names of a plurality of parsers are consolidated. One or more of the table names, the column names, and the function names are replaced with corresponding names that are compatible with SQL-syntax of a second database. A result comprising the consolidated table names, the consolidated column names, the consolidated function names, and replaced names is generated.

主权项

1. An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:
split a structured query language (SQL) query of a first database into tokens and traverse the query from a first token; when a keyword token is encountered, create a current parser to store a table name and a column name associated with the encountered keyword token; when an open parenthesis is encountered, store a token immediately preceding the open parenthesis as a function name in the current parser, wherein the function name is specific to the first database; consolidate table names, column names, and function names of a plurality of parsers; replace one or more of the table names, the column names, and the function names with corresponding names that are compatible with SQL-syntax of a second database; and generate a result comprising the consolidated table names, the consolidated column names, the consolidated function names, and replaced names.