BSQL

BSQL is an SQL query application wrapped in a user-friendly interface, with support for Oracle, SQL Server, Microsoft Access, MySQL and Sybase. It features auto code completion along with keyword and object filling, in addition to an advanced SQL query editor and script building.

The tool is designed for those looking to quickly put together detailed database reports in various formats, such as HTML, Microsoft Excel (XLS, XLSX), RTF, XML and PDF.

To get started, it's necessary to connect to a database by selecting the DBMS (Access, SQL Server, Oracle, MySQL, SQL Anywhere, Sybase) and by specifying the username, password, server, database file, and port number. The application is capable of remembering your password so you can quickly log in next sessions. You can test connection before applying settings to make sure everything is operational.

It's possible to establish multiple connections, use the object explorer for procedures, functions, templates, user tables, system tables and views, check the syntax, parse and execute queries, as well as create, delete and export queries to file.

Also, you can comment lines and blocks, display the output view to analyze log details, as well as enable or disable auto-completion for tables, views, fields, databases, procedures, snippets, operators or keywords.

Besides customizing the font, you can convert selected text to lowercase or uppercase, change text color, add catalogs, and find and replace items. Reports can be previewed and printed.

You can customize the toolbars, restrict search operations to tables, columns, indexes, relations, triggers, perform a full text search, extract the database, export by template, as well as create, drop, select, insert, update and delete scripts.

There's also a fully featured report designer with selection, hand, zoom, text edit, format copy, band insert, text object, picture object, subreport object, system text and drawing tools available.

All things considered, BSQL proves to be a capable SQL utility for designing and generating detailed SQL reports.