Benthic Software: GoldSqall 2.x 2.4.0.244

• New portable application mode via command-line options or marker file.
• Several fixes to editing tables using a uuid primary key in PostgreSQL.
• Improved database file selection for SQLite, DuckDB and Firebird local databases.
• Fix for SQLBuilder refresh on Oracle cloud connections.
• Version information added to DuckDB diagnostics.
• Changes to Summarize and Pragma statements so no special handling is necessary.
• Several changes for high DPI per monitor support.
• Improvements to the login window for dark mode.
• New export/import all options choices on the login window (useful for portable mode.)

• Several fixes and improvements to the DuckDB protocol.
• Fixed an issue pasting single cells from Excel into the bind variable prompt window.
• Allow empty field delimiter in export options.
• Updates to the MySQL and SQLite protocols.

- New native protocol for DuckDB!
- Greatly improved SQL Formatter with new keyword casing and prefixed comma options.
- New "Case only" formatting action.
- New "Autosave directory" option.
- New /*-*/ prefix for bypassing a local command to process it on the server as a command.
An example would be the DuckDB "export" command which conflicts with our local export command. To run that command on the server use:
/*-*/export database 'filename';
- New /*+*/ prefix for bypassing a local command and/or to force it to be handled as a query.
A good exmple of this is SQLite's PRAGMA statement which can be run and returns results by using:
/*+*/ PRAGMA main.table_info('mytable');
- Updated help section "How to use the SQL Formatter".