help developer generator a insert SQL statement
nodejs stream for .csv to MySQL USE, CREATE and INSERT .sql
Tools for working with PGlite databases
Fastest full featured PostgreSQL client for Node.js
Transparent, Schemaless SQL Generation
Generate Zod schemas from Drizzle ORM schemas
Microsoft Driver for Node.js SQL Server compatible with all versions of Node.
Summarize any SQL query
Utilities for SQL instrumentations
Read named SQL statements from .sql files. Also named parameters for prepared statements.
An SQL-friendly ORM for Node.js
nodejs stream for .csv to MySQL USE, CREATE and INSERT .sql
Format whitespace in a SQL query to make it more readable
A simple and lightweight library for highlighting SQL queries written in pure JavaScript
<a href="https://waddler.drizzle.team">Website</a> • <a href="https://waddler.drizzle.team/docs/overview">Documentation</a> • <a href="https://x.com/drizzleorm">Twitter</a> • by [Drizzle Team](https://drizzle.team)
PGlite is a WASM Postgres build packaged into a TypeScript client library that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It is only 3.7mb gzipped.
🛡️ Faster SQL escape and format for JavaScript (Node.js, Bun, and Deno).
SQL language support for the CodeMirror code editor
simple node sql parser
A JavaScript library for connecting securely to your Cloud SQL instances
A SQL query identifier
Simple SQL escape and format for MySQL
A TDS driver, for connecting to MS SQLServer databases.
sql-bricks extension for MySQL
A library for bulk inserting data using ActiveRecord and SQL Server.
generate bulk insert without ActiveRecord.
Fluentd plugin to insert into Microsoft SQL Server.
Speeds up seeding database using multiple SQL inserts
= sql_valued_columns SqlValuedColumns is an ActiveRecord plugin that will let you have specific SQL statements executed on INSERT / UPDATE. It will call the SQL function you provide, passing the arguments specified in the call to sql_column. See the documentation for SqlValuedColumns::ClassMethods#sql_column for more information regarding usage, including passing Strings and Proc objects as arguments to your SQL function. Example: You have a model with two columns, one named "another_column" and the other named "size_of_another_column". Whenever you insert data into "another_column", you want to have size_of_another_column have the result of the SQL function LENGTH inserted into it. class MyModel < ActiveRecord::Base sql_column :size_of_another_column, "LENGTH", :another_column end Example 2: You have a model with three columns, position, latitude and longitude. Latitude and longitude are values expressed as angles, and position is a special datatype for your database that represents the X/Y/Z projection of that particular latitude and longitude (example: http://www.postgresql.org/docs/8.3/static/earthdistance.html ) When you insert data with latitude and longitude, you want to automatically call a function in your database to transform the latitude and longitude into the appropriate represenation. class MyModel < ActiveRecord::Base sql_column :position, "ll_to_earth", :latitude, :longitude end Example 3: You are an insane criminal who has somehow learned SQL. You would like to make anyone who runs your code to suffer database punishing queries and odd security and data formatting issues that will make them rue the day they ever learned of computers. class MyModel < ActiveRecord::Base sql_column :a_column, "(SELECT count(id) FROM large_list_of_things)", :raw => true sql_column :another_column, '(SELECT count(other_id) FROM other_large_list_of_things WHERE some_column = \'#{some_model_method}\')', :raw => true end == Notes No tests yet, am lazy. == Copyright Copyright (c) 2009 Chris Zelenak. See LICENSE for details.
Simple DSL for multi-row SQL INSERT statements
ActiveRecord-JDBC fetches ids of inserted records when you call connection.execute(). this gem adds a connection.execute_raw() method which does not fetch inserted ids
Generate the SQL to insert a single record and all of its dependencies
This is a custom gem that extends ActiveRecord to enable the expression of SQL `INSERT INTO ... SELECT ...` queries in a more convenient way. It allows you to copy data from one table to another based on specified conditions using a simple and expressive syntax.
Use raw SQL to insert database records in bulk. Supports uniqueness constraints, timestamps, and checking for existing records.
sql_tagger inserts stack trace comments into SQL queries.
A command line tool to generate SQL insert or update statements from the data in a database.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.
No description provided.