Marin Nozhchev

Batch insert in \copy to DB destination

1

Most databases support multi-row INSERT statements so it is possible to speed up \copy by using batches. This issue is discussed in the PR for Clickhouse \copy implementation - https://github.com/xo/usql/pull/457...

fix(oracle): use view available for all users for driver.Version

2

Closes #489 Use v$version instead of v$instance because it is available to all users. Like v$instance, v$version is available in all non-ancient oracle versions. Both are available in the earliest...

bulk load for MySQL

2

The PR implements bulk loading for MySQL using the "LOAD DATA from io.Reader" feature of github.com/go-sql-driver/mysql - https://github.com/go-sql-driver/mysql?tab=readme-ov-file#load-data-local-infile-support . As expected, bulk loading this way is significantly faster. 1 mln....

Fix substitution of quoted variables

1

testcli.go failed before the fix and passes after it. Also includes a fix to testcli.go itself. Closes #505 .

The following works on the latest release v0.19.14 but fails on master. This is also why the PR checks fail:  On master, the interactive console thinks that there is...