Sqlparse - A non-validating SQL parser module for Python

  •        107

sqlparse is a non-validating SQL parser for Python. It provides support for parsing, splitting and formatting SQL statements.

https://github.com/andialbrecht/sqlparse

Tags
Implementation
License
Platform

   




Related Projects

SQL Parser for Delphi

  •    Delphi

Develope a string parser that is capable to parse SQL statements into tokens, allows changing theese tokens and rebuilding (modified) SQL statement

sql-parser - A SQL parser written in pure JS

  •    Javascript

SQL 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...

SQL Server and SQL Azure Performance Testing: Enzo SQL Baseline

  •    

Run SQL statements in SQL Azure (or SQL Server) and capture performance metrics of your SQL statements (reads, writes, CPU...) against multiple databases. Run your statements in parallel, view performance results side-by-side and export to Excel for further analysis.

Open SQL Parser

  •    Javascript

Open SQL Parser is a database independant SQL parser written in PHP.

Parser SQL Query

  •    C++

Class 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 '$'.


SQLDelight - Generates Java models from CREATE TABLE statements

  •    Kotlin

SQLDelight generates Java models from your SQL CREATE TABLE statements. These models give you a typesafe API to read & write the rows of your tables. It helps you to keep your SQL statements together, organized, and easy to access from Java. To use SQLDelight, put your SQL statements in a .sq file, like src/main/sqldelight/com/example/HockeyPlayer.sq. Typically the first statement creates a table.

SQL Bandwidth Meter Log Parser

  •    

Parses the log files created by the Hosts Tools SQL Bandwidth Meter application

jinjasql - Simplify creation and maintenance of complex SQL queries by using Jinja based template language

  •    Python

JinjaSQL 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.

WowPacketParser - World of Warcraft Packet Parser

  •    CSharp

Optionally, 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.

Sql Script Generator

  •    

Sql Script Generator is a tool for generate INSERT/UPDATE statement sql script. With Sql Script Generator you can create script to copy data from one database to another. In current version there are this feature: - Generate only INSERT and UPDATE statements; - Run in transa...

SQL Workbench - DBMS-independent SQL query tool

  •    Java

SQL Workbench is a DBMS-independent, cross-platform SQL query tool. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. It could compare the data of two database and generate the necessary SQL statements to migrate one to the other.

MacroScope

  •    CSharp

MacroScope is a portable SQL ADO.NET provider, automagically transforming SQL commands to a form expected by different database engines. It also includes an SQL parser and exports an SQL object model.

datafusion - SQL Query Execution against Apache Arrow, in Rust

  •    Rust

DataFusion 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.

SQL-Viewer

  •    

The SQL-Viewer is a Visual Studio 2008 Add-In for C# to store SQL-Statements in an XML-File and obtain it from there. So there will be no SQL-Statements in the code, just get it from the Add-In.

pgdiff - Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database to make their schemas match

  •    Go

pgdiff compares the schema between two PostgreSQL 9 databases and generates alter statements to be manually run against the second database to make them match. The provided pgdiff.sh script helps automate the process. pgdiff is transparent in what it does, so it never modifies a database directly. You alone are responsible for verifying the generated SQL before running it against your database. Go ahead and see what SQL gets generated.

.NET Dynamic SQL Generator

  •    CSharp

A 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

Convert Ms Word Table to Sql Table

  •    

This utility would help convert Ms word 2007 Tables to Sql tables. Add this macro to any word docx document and Run the macro. We get a text file containing all the tables which follow the naming convention converted into sql DDL statements. You just need to follow some naming

JavaScript SQL (JSSQL)

  •    Javascript

A database engine entirely in JavaScript (AJAX)

zevenseas SharePoint SearchCoder

  •    

Complete toolkit for building and testing SharePoint Enterprise Search SQL Statements. It comprises of two key tools: 1) Object model for creating SQL statements in code. 2) Windows Application for building: a) SharePoint Search SQL b) C# Code that uses the OM to build...