- fix CTE aliased column bug
- UPSERT
- ALTER DATABASE
- ALTER NAMESPACE
- ALTER TABLE
- DROP NAMESPACE
- Foreign Key Referential Integrity
- sys.foreign-keys view
- full @ta and @tas aura support
- action %tape executes silently, %tape-print prints to dojo
- fixed bug where system views were not ordered
- fixed bug where SELECT sub-set of system view columns returned duplicate rows
- fixes to constant scalar function processing and missing scalars
- fixes and improvements to obelisk ui
- UI: all aspects significantly faster
- UI: multi-command scripts have tabbed results
- UI: copy script or result to clipboard
- UI: paging of long result sets
- Common Table Expressions (CTE)
- Scalar Functions
- All Natural Joins
- JOIN ON Predicate
- Set Operators UNION, INTERSECT, EXCEPT
- %hawk UI
- OTA Software Distribution
- UPDATE
- NOT unary predicate operator fully functional
- documentation reorganized
- SELECT all from table in JOIN
- CROSS JOIN
- natural JOIN on primary keys when key column ordering differs
- support multiple natural JOINs and CROSS JOINs
- sys.tables view changed and sys.table-keys view added
- refactored multiple AST components
- add unqualified-column to AST/API
- fixed several JOIN bugs
- updated docs
- GRANT and REVOKE parsing and AST updated.
CREATE DATABASE DROP DATABASE CREATE NAMESPACE CREATE TABLE DROP TABLE
- Database schemas are time-travelling (cf. Preliminaries: Time section).
- Several other DDL commands can be parsed, but the %obelisk engine does not yet enable them.
INSERT TRUNCATE TABLE FROM...SELECT...
- FROM user-defined tables and system views (views on the database schema and history).
- Natural JOINs -- a natural join has no predicate, rather it joins on columns that match both in name and aura.
- Cross-database JOINs -- natural joins.
- Tables and views are time-travelling.
- SELECT any or all available columns and literals.
- WHERE clause predicates for filtering query results.