A validating SQL lexer and parser with a focus on MySQL dialect. The API documentation is available at https://develdocs.phpmyadmin.net/sql-parser/.
https://packagist.org/packages/phpmyadmin/sql-parserTags | sql-query sql-parser mysql sql parser sql-builder |
Implementation | PHP |
License | GPL |
Platform | Windows Linux |
SqlKata Query Builder is a powerful Sql Query Builder written in C#. It's secure and framework agnostic. Inspired by the top Query Builders available, like Laravel Query Builder, and Knex.
sql-query-builder sql-server postgresql mysql c-sharp database query-builder sql-query sql activerecord data-access-layerClass C++ of parse SQL query. Simple, but effective to add a condition to the SQL query of any complexity or replace a variable by its value. Variable begins with a '$'.
parser sql visual-studio-2010sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.
sql-parser sql-statements sql parserphpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.
database-front-end adminstration tool mysql-admin mysql-management mysql-toolOptionally, WPP can connect to two kinds of MySQL databases: world from TrinityCore and its own database, WPP. This can be enabled by setting <add key="DBEnabled" value="true" /> in the .config file. Remember to set <add key="TargetedDatabase" value="1"/> in accordance with the targeted version of the core. The world database is used when creating SQL files after parsing to produce the mimimum number of changes needed to update the database. For example, if only the faction of a creature that appears in the sniff needs to be updated, the produced SQL files will contain an UPDATE query, instead of a full INSERT to the table creature_template. WPP does not modify this database directly, all the tentative changes will be written to the output SQL files.
sniff wow parser c-sharp wppSQL Parser is a lexer, grammar and parser for SQL written in JS. Currently it is only capable of parsing fairly basic SELECT queries but full SQL support will hopefully come in time. See the specs for examples of currently supported queries. The package is distributed on NPM and can be installed with...
Knex.js is a "batteries included" SQL query builder for Postgres, MSSQL, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.
query-builder async sql query sql-query-builderIn order to start using goqu with your database you need to load an adapter. We have included some adapters by default. Adapters in goqu work the same way as a driver with the database in that they register themselves with goqu once loaded.
sql sql-statement sql-builder database postgresql mysql sqlite sql-query sql-generationObjection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while keeping magic to a minimum.Objection.js is built on an SQL query builder called knex. All databases supported by knex are supported by objection.js. SQLite3, Postgres and MySQL are thoroughly tested.
orm knex sql query query-builder postgresql mysql sqlite3DataFusion is a SQL parser, planner, and query execution library for Rust. A DataFrame API is also provided. DataFusion can be used as a crate dependency in your project to add SQL support for custom data sources.
spark sql dataframe cluster compute data arrowPyPika is a Python API for building SQL queries. The motivation behind PyPika is to provide a simple interface for building SQL queries without limiting the flexibility of handwritten SQL. Designed with data analysis in mind, PyPika leverages the builder design pattern to construct queries to avoid messy string formatting and concatenation. It is also easily extended to take full advantage of specific features of SQL database vendors. PyPika supports python 2.7 and 3.3+. It may also work on pypy, cython, and jython, but is not being tested for these versions.
sql functional python27 python3 builder pythonic querySimple SQL parser meant for querying CSV files
parser csv sqlA Database agnostic SQL query builder and Data Access Layer for .NET. Build safe SQL Statements using familiar syntax and execute on any database with minimal effort. Written in C# using VS 2008
data-access-layer dynamic-sql query-builder sql sql-serverProvides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. These builders are independent of any particular database connection library, although PDO in general is recommended. This package is installable and PSR-4 autoloadable via Composer as aura/sqlquery.
query-builder mysql postgresql microsoft-sql-server sqliteJinjaSQL is a template language for SQL statements and scripts. Since it's based in Jinja2, you have all the power it offers - conditional statements, macros, looping constructs, blocks, inheritance, and many more. JinjaSQL doesn't actually execute the query - it only prepares the query and the bind parameters. You can execute the query using any database engine / driver you are working with.
sql sql-builder jinja2 sql-injection sql-queryParses the log files created by the Hosts Tools SQL Bandwidth Meter application
bandwidth log-viewer logviewer sql sql-2005 sql-2008 sql-serverSQL Buddy is a phpMyAdmin alternative with a focus on usability. It supports to create and drop databases and tables, View, edit, insert and delete table rows, Execute custom SQL and view the output, Import and export databases and tables to SQL and CSV formats, Add, edit and delete MySQL users.
database-front-end adminstration tool mysql-admin mysql-management mysql-toolDevelope a string parser that is capable to parse SQL statements into tokens, allows changing theese tokens and rebuilding (modified) SQL statement
Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.
mysql postgres mongo sql-server orm database mongodb sqlite postgresql mariadb mssql sqlserver mongodb-orm prisma-client nodejs-orm rest-api database-migration
We have large collection of open source products. Follow the tags from
Tag Cloud >>
Open source products are scattered around the web. Please provide information
about the open source projects you own / you use.
Add Projects.