Search Results for "select"

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.

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.

LazLiteDB can create and utilize multi-table SQlite databases with report capability. It provides an editor to create SQLite tables and maintain the table structure. For day to day data entry, LazLiteDB provides a user friendly interface with custom reports. See ReadMe.txt file for version updates

...*Creates table base on data from a relational database *Generate a pivot report using the same external connection (1) *Some ad-hoc tools are available - like "keep only" and "remove only" *you can use the row limit option for exploring the largest dataset *The ODBC connection manager is available *auto-build query tool can create SQL select statement by using different database tables with matching them by column name * creating connections for PowerQuery news and updates -- change list -- v05 beta export tables and SQL to CSV files treat CSV like relational tables -- add Cloud ClickHouse Source resolve the problem with an untrusted source changed Sql Editor fixed behavior for "update rows"

...Each exercise includes clear expected output so learners can compare their query results against the intended answer. The later questions require chaining joins and grouping data, which gives beginners a practical path beyond simple SELECT statements. It is best suited for students or self-taught developers who want guided SQL repetition instead of abstract database theory.

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.