Use SQLLine for headless mode

[vlsi]

https://github.com/julianhyde/sqlline

1. It can be interactive
2. It can execute script from file as well
3. It has multiple output formats (csv, tsv, json, xml, pretty-printed, etc)

[snuyanzin]

+1, could add 1 more point related to the first bullet.
jline3 (internal sqlline's engine) supports expansions which is similar to IDE's live templates.
For instance there could be snp for

select
 p.this
from 
 java.util.Properties p

snpnn for

select
 p.this
from 
 java.util.Properties p
where
 asMap(p.this)['java.vm.version'] is not null

and plenty of others which could be configured