HoneySQL is a Clojure library that transforms data-structure-based query descriptions into SQL strings (with parameter separation). It focuses purely on generation—leaving execution to libraries like next.jdbc. It supports complex constructs (JOINs, subqueries, CTEs), and allows dynamic query-building with safety and readability.
Squel is a JavaScript library for fluent and safe SQL query string building, usable both in Node.js environments and in the browser. Works in Node.js and in the browser. Supports the standard SQL queries: SELECT, UPDATE, INSERT, and DELETE. Supports non-standard commands for popular DB engines such as MySQL. Supports parameterized queries for safe value escaping. It can be customized to build any query or command of your choosing. Uses method chaining for ease of use.
SQL-Kitten is a generic sql client written in Java that can be used to connect to any jdbc compliant database. Some features are: Run SQL queries, Search within resultsets, Easy insert/update/delete, insert/update CLOB and BLOB datatype
Fast GUI based multilanguage database client (in perl/DBI/Tk). Supports most databases, runs on Windows / Unix / Linux. Powerfull SQL editor, view data in spreadsheets, powerfull filter tools. Form to edit/insert datasets. Highly configurable.
SQL editor for Oracle, MS-SQL, CA-Ingres, InterBase, Access, MySQL, PostgreSQL, etc. Table structures, indexes, exec. plans! Syntax highlight. CTRL+Space: commands and tables. Creates SELECT, INSERT, UPDATE, and DELETE. In english, french or portuguese.