v0.14.0
FunSQL v0.14.0
Define
: add parametersbefore
andafter
for specifying position of the defined columns.- Introduce the
SQLColumn
type to represent table columns. The type ofSQLTable.columns
is changed fromVector{Symbol}
toOrderedDict{Symbol, SQLColumn}
. - Make
SQLTable
anAbstractDict{Symbol, SQLColumn}
. - Add DataAPI-compatible metadata to catalog objects
SQLCatalog
,SQLTable
, andSQLColumn
. - Add a field
SQLString.columns
with an optionalVector{SQLColumn}
representing output columns of the SQL query. - Support docstrings in
@funsql
notation. - Remove support for
const
and variable assignment syntax from@funsql
notation. - Use a simpler and more consistent rule for collapsing JOIN branches (fixes #60).
Merged pull requests:
- Define: add 'before' and 'after' parameters (#62) (@xitology)
- Support docstrings in @funsql notation (#63) (@xitology)
- Metadata interface for catalog objects (#64) (@xitology)
Closed issues:
- Adding multiple qualifiers to table results in joins being subqueries (#60)