FunSQL.jl

FunSQL is a Julia library for compositional construction of SQL queries.

Table of Contents

• Usage Guide
• • Test Database
  • Database Connection
  • Database Schema
  • Why FunSQL?
  • Tabular Operations
  • From, Select, and Define
  • Join
  • Scalar Operations
  • Lit
  • Get
  • Fun
  • Group and Aggregate Functions
  • Partition and Window Functions
  • Query Parameters
  • Correlated Queries
  • Order and Limit
  • Append and Iterate
• API Reference
• • SQL Dialects
  • SQL Entities
  • SQL Statements
  • Semantic Structure
  • Syntactic Structure
• Examples
• • Establishing a database connection
  • Importing FunSQL
  • Database introspection (SQLite)
  • Database introspection (PostgreSQL)
  • Database introspection (MySQL)
  • Database introspection (Microsoft SQL Server)
  • Database introspection (Amazon RedShift)
  • SELECT * FROM table
  • WHERE, ORDER, LIMIT
  • SELECT COUNT(*) FROM table
  • SELECT DISTINCT
  • Filtering output columns
  • Output columns of a Join
  • Encapsulating complex SQL expressions
  • Assembling queries incrementally
  • Merging overlapping intervals
• Test Suite