FunSQL.jl

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

Table of Contents

• Usage Guide
• • Test Database
  • Using FunSQL
  • Why FunSQL?
  • Tabular Operations
  • From, Select, and Define
  • Join
  • Scalar Operations
  • Lit: SQL Literals
  • Get: Column References
  • Fun: SQL Functions and Operators
  • Group and Aggregate Functions
  • Partition and Window Functions
  • Query Parameters
  • Correlated Queries
  • Order and Limit
  • Append and Iterate
• API Reference
• • render()
  • reflect()
  • SQLConnection and SQLStatement
  • SQLCatalog, SQLTable, and SQLColumn
  • SQLDialect
  • SQLString
  • SQLNode
  • Agg
  • Append
  • As
  • Bind
  • Define
  • From
  • Fun
  • Get
  • Group
  • Highlight
  • Iterate
  • Join
  • Limit
  • Lit
  • Order
  • Over
  • Partition
  • Select
  • Sort, Asc, and Desc
  • Var
  • Where
  • With
  • WithExternal
  • SQLClause
  • AGG
  • AS
  • FROM
  • FUN
  • GROUP
  • HAVING
  • ID
  • JOIN
  • LIMIT
  • LIT
  • NOTE
  • ORDER
  • PARTITION
  • SELECT
  • SORT, ASC, and DESC
  • UNION
  • VALUES
  • VAR
  • WHERE
  • WINDOW
  • WITH
• Examples
• • Importing FunSQL
  • Establishing a database connection
  • Database connection with LibPQ.jl
  • SELECT * FROM table
  • WHERE, ORDER, LIMIT
  • SELECT COUNT(*) FROM table
  • SELECT DISTINCT
  • Generating a complex CASE clause
  • Filtering output columns
  • Output columns of a Join
  • Querying concepts
  • Assembling queries incrementally
  • Merging overlapping intervals
• Test Suite
• Two Kinds of SQL Query Builders