usql v0.9.4

Point release:

• Adds Exasol database support
• Adds support for ClickHouse metadata

usql v0.9.3

General updates and enhancements:

1. Fixes to MySQL and Oracle metadata completion
2. Reworked \i and \ir commands to work better with large files
3. The go-ora and godror drivers now share common package
4. Updated database drivers

usql v0.9.2

Point release:

• Added additional query recognition for sqlserver and oracle databases
• Fixed issues with some queries for oracle
• Updated database drivers
• General code cleanup

usql v0.9.1

Point release: bug fixes and fully static builds.

• Updated all drivers to latest versions
• Fixed column alignment issues with the mysql driver
• Fixed logic to prevent panics in certain situations
• build-release.sh script updated to support fully
• Converted environment variable TIME_FORMAT to \pset time <format> variable, and fixed formatting issues

usql v0.9.0

New major features:

• Enabled autocomplete for \ commands (including files for \i, DSNs for \c, fields for \pset) and context-based completion for SELECT, UPDATE, INSERT, DELETE queries and variables
• Added a \copy command to copy data between different databases (local files are not supported yet)
• Added a \crosstab command
• Added a \G exec command that outputs in a vertical format (ala mysql)
• Added a \watch command
• PAGER support
• Added \o and \qecho commands to send output to files or pipe to other system commands
• Added the optional FILE argument to \g and \gx to send their output to a file or pipe to other system commands; the commands also support passing formatting options
• Support the unaligned, tuples_only, html and asciidoc output formats
• Context propagation and cancellation (CTRL+C) for in-flight queries

New Database Support:

• Netezza
• csvq - supports CSV, TSV, JSON and other flat files

Other fixes/improvements:

• Added a -G for vertical output (see \G above)
• Added a -q flag and associated QUIET environment variable to enable quiet output
• Implement the auto option for the \x command
• Fixed issues with escaped and other special characters when \set-ting variables
• The \begin transaction command now supports all of Go's transaction isolation levels, and read-only support
• \d updated to print relations, foreign keys, and other constraints for tables
• The \d* commands now provide more information and work better with some databases; they also do a better job of hiding system objects by default
• \d command support for the Snowflake database
• Now sets the ROW_COUNT variable for DML queries
• Fixes table titles

Notes:

• CONTRIBUTING.md has been updated with details on implementing \d* / autocomplete for other databases

usql v0.8.2

General release with:

• Bug fixes
• Native Go driver for Oracle now included by default (previous driver still available as godror)
• Added support for a number of experimental databases
• Minor enhancements to table output to better mimic psql
• Initial \d* and other meta/introspection commands

usql v0.7.8

Maintenance release:

• Updates driver dependencies
• Fixes propagation of statement configuration based on the driver for included scripts (\i, \ir, -f)

usql v0.7.7

Minor update from previous release, updating to fixed Vertica driver.

usql v0.7.6

Addition of Vertica database and updates to latest drivers/package dependencies.

usql v0.7.5

No substantial feature updates from previous v0.7.x builds; maintenance release, primarily updating third-party package dependencies.