FunSQL.jl
FunSQL.jl copied to clipboard
Julia library for compositional construction of SQL queries
The `@funsql` macro was officially released in v0.12.0. Going forward, it should become a preferred method for assembling FunSQL queries. For this reason, the documentation, in particular, Usage Guide, API...
FunSQL requires the `=` operators for comparison, as there are no methods defined for `≥` or `≤`. Example: ``` julia> using FunSQL julia> @funsql begin from(person) filter(1930 ≤ year_of_birth ≤...
In some cases there is good reason to have slots in a query frame that are available to be included, but would not want to be added by default. For...
```Julia render(conn, From(:anytable) |> Select(:rowid)) ``` produces an error: ReferenceError: cannot find `rowid` ```julia render(conn, From(:anytable) |> Select(“rowid")) ``` Almost works but it produces `SELECT ‘rowid’ AS “_”`
Currently, as I understand, `SQLCatalog` only contains metadata for a single schema in a database. This makes it impossible to query tables from multiple schemas at once. Would be useful...