A quick reminder of all SQL queries and examples on how to use them.

Quick SQL Cheatsheet A quick reminder of all relevant SQL queries and examples on how to use them. This repository is constantly being updated and added to by the community. Pull requests are welcome. Enjoy! Table of

Related Repos



OneCodeLabs reminder reminder lets you persist the state of your views to recover them later in order to display old data until fresh data arrives. Usage Initialize Reminder: public class MyApplication extends Appl
 

ianstormtaylor pg-sql-helpers A set helpers for writing dynamic SQL queries with pg-sql in Javascript. It's sort of like a lodash or polished for writing SQL. Features Uses a simple, SQL-like syntax for building queries. Ena
 
1.4k

kayak PyPika - Python Query Builder Abstract What is PyPika? PyPika is a Python API for building SQL queries. The motivation behind PyPika is to provide a simple interface for building SQL queries without limiting
 

ghdna Athena-Express: Simplifying SQL queries on Amazon Athena As published on the official AWS Partner Network Blog Synopsis Athena-Express can simplify executing SQL queries in Amazon Athena AND fetching
 

johndatserakis Chrome-Ribbon-Reminder This is a Chrome extension in popup form. Ribbon Reminder was an old app I made in Swift for iOS a while back, and I think its
 

jhspetersson fselect Find files with SQL-like queries Why use fselect? While it doesn't tend to fully replace traditional find and ls, fselect has these nice features: complex queries SQL-like (not real SQL, but highly rel
 

steventen Rails SQL Query Tracker sql_tracker tracks SQL queries by subscribing to Rails' sql.active_record event notifications. It then aggregates and generates report to give you insights about all the sql queries happened in your Ra
 

jarulraj What Is SQLCheck? sqlcheck automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries. sqlcheck targets all major SQL dialects.
 

hashedin Build Readonly JSON APIs from SQL Queries Squealy lets you build readonly REST APIs from template-based SQL or JSON queries. It supports most relational databases, and some NoSQL databases like ElasticSearch. The SQL query is wr
 

houqp Sqlvet Sqlvet performs static analysis on raw SQL queries in your Go code base to surface potential runtime errors at build time. Feature highlights: Check for SQL syntax error Identify unsafe queries that could potent
 

Orange-Cyberdefense Arsenal is just a quick inventory, reminder and launcher for pentest commands.
 

nils-braun It lets you register your dask dataframes and then run SQL queries against them. The queries will run as normal dask operations, which can be distributed within your dask cluster. The goal is therefore similar to what Spark SQL/Hive/Drill/... is for the Hadoop world - but with much less features (so far...)
 

dantheman213 Ocean SQL Profiler Cross-platform SQL profiler for PostgreSQL 9.3+. View your queries and functions being run in real-time in a simple to use GUI. Features View your PostgresSQL functions and queries being exec
 
60

tyler-smith golang-db-sql-benchmark A collection of benchmarks for popular Go database/SQL utilities Libraries under test database/sql + go-sql-driver/mysql gocraft/dbr Gorp Sqlx Squirrel database/sql SQL
 

hyperdivision prepare-sql SQL template strings Usage var SQL = require('prepare-sql') const username = 'emilbayes' // Query with template string const select = SQL`SELECT * FROM users WHERE username = ${username}` const
 

sqorn Sqorn · Sqorn is a Javascript library for building SQL queries. Composable: Build complex queries from simple parts. Chain, extend, and embed queries. Intuitive: Sqorn's use of modern Javascript language features like tag
 
3.5k

querydsl Querydsl Querydsl is a framework which enables the construction of type-safe SQL-like queries for multiple backends including JPA, MongoDB and SQL in Java. Instead of writing queries as inline strings or externalizing them into
 

ZewoGraveyard SQL SQL provides Base conformance for SQL database adapters Typesafe table representations and queries (select, insert, join, etc.) A powerful, non-intrusive ORM Installation The SQL module is bun
 

microsoft Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
 

whtsky Vuex-Queries Vuex-Queries helps you write query functions in Vuex Usage Write your queries in Vuex options: const options = { state: { events: [
 

ververica The Apache Flink SQL Cookbook is a curated collection of examples, patterns, and use cases of Apache Flink SQL. Many of the recipes are completely self-contained and can be run in Ververica Platform as is.