SQL DML Script files usually consist of multiple SQL statements
and sometimes designed to be executed from outside the database, and therefore
not necessarily compiled in the database. Such scripts are often handcrafted and
sometimes generated or part of the database utilities (e.g. Teradata fastload,
bulkload and multiload)
Parsing of independent SQL script files (.sql) is
currently limited to the following database technologies:
o Apache Hadoop Hive Database (Cloudera, Hortonworks, MapR) SQL DML (DI/ETL) Script (HiveQL)
o Apache Sqoop
o IBM DB2 Universal Database (UDB) SQL DML (DI/ETL) Script
o Microsoft SQL Server Database SQL DML (DI/ETL) Script (Transact-SQL)
o Oracle Database SQL DML (DI/ETL) Script (PL/SQL)
o PostgreSQL Database SQL DML (DI/ETL) Script
o Teradata Database SQL DML (DI/ETL) Script (BTEQ, Fastload, etc.)