StelsCSV is a CSV JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on text files (comma-separated, delimiter-separated, fixed-length, etc).
Also, the driver can be used for writing data importing applications and migration tools.
Here are some key features of "StelsCSV":
· It supports most keywords of ANSI SQL'92
· It supports inner and outer table joins
· It supports INSERT, UPDATE and DELETE statements
· It supports transactions
· It supports integer, floating point, string and date/time data types
· It supports aggregate, converting, string and other SQL functions
· It supports user-defined SQL functions
· It supports reading text files from Zip/Jar archives and HTTP URLs
· It is platform independent