Support for INTERVAL expression.
Warnings added when unknown data types, operators and expressions are found.
Error statement added to the views with missing dependencies.
Overall improvements in the issues' names and codes.
Added support for conversion of
SELECT... FROM table_name TABLE(...)
Several stability bugfixes for large conversions.
Identifiers with special characters are correctly converted
macOS - the Start Over button was causing unexpected behavior.
New Functions translation: RANK, DENSE_RANK, EMPTY_BLOB, EMPTY_CLOB
Be able to parse procedure and some procedure statements such as OPEN, CLOSE, FETCH, FOR LOOP, FORALL, CONTINUE, NULL, etc...
Known Issue: macOS - the Start Over button can cause unexpected behavior.
CREATE Synonyms translation
Add warning for ROWNUM, ROWID, JSON_TABLE and XML related functions like XMLSEQUENCE, EXTRACTVALUE, EXTRACT (XML)
Translate new functions like: CAST, LISTAGG, NLSSORT, UNISTR, CHR, SUBSTR
Translate AT TIME ZONE expression
Convert more built-in Functions:
FIRST and LAST
Convert unsupported built-in functions that require manual effort to a
Convert basic data types such as
Convert the following Functions: (for all the functions, if there are something that doesn't have an equivalence in snowflake, we may add a WARNING to the output code)
TO_CLOB(bfile | blob)