FunSQL.jl
FunSQL is a Julia library for compositional construction of SQL queries.
Table of Contents
- Usage Guide
- API Reference
render()
reflect()
SQLConnection
andSQLStatement
SQLCatalog
andSQLTable
SQLDialect
SQLString
SQLNode
Agg
Append
As
Bind
Define
From
Fun
Get
Group
Highlight
Iterate
Join
Limit
Lit
Order
Over
Partition
Select
Sort
,Asc
, andDesc
Var
Where
With
WithExternal
SQLClause
AGG
AS
FROM
FUN
GROUP
HAVING
ID
JOIN
LIMIT
LIT
NOTE
ORDER
PARTITION
SELECT
SORT
,ASC
, andDESC
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