FunSQL.jl icon indicating copy to clipboard operation
FunSQL.jl copied to clipboard

Julia library for compositional construction of SQL queries

Results 26 FunSQL.jl issues
Sort by recently updated
recently updated
newest added

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...

documentation

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 “_”`

enhancement

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...