Caigen CSV is a CSV JDBC type 4 driver that allows to perform SQL operations on raw data, flat text , CSV file, TSV file, PSV file, fixed-length, and variable-length binary file.

* It supports ANSI SQL 92 standard, and more than 230 sql functions. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, GROUP_CONCAT, GROUPING, WITH ROLLUP, WITH CUBE, multiple-row VALUES table, PIVOT table, UNPIVOT table, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery.
* It supports transactions.
* It supports data mining on memory database, compressed database(.ZIP, .JAR, .GZ, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2), SAMBA database(smb), and url database(http, https, ftp).
* It is completely platform-independent and can be deployed on any platform with Java VM, which includes Microsoft Windows, Novell Netware, Apple Mac OS, Solaris, SCO Unix, OS2, OS/400, AIX OS, Tandem OS, MPE OS, FreeBSD, IRIX, OSF/1, OpenVMS, Guardian, UNIX, and LINUX.