JEQL Language & Engine
Version History
This document lists the change history of versions of the JEQL Language & Engine
Version 0.9
Release Date: January 5, 2011
Functionality Improvements
User Interface
- Now accepts scripts from stdin (using the command 'jeql -stdin')
Language Syntax & Semantics
Performance
- Indexing is now supported for JOIN clauses with a simple equality ON condition
Standard Library
- Added initial release of Geodetic
Library Changes
- Value module renamed to Val
Version 0.8
Release Date: December 12, 2009
Functionality Improvements
User Interface
- Now accepts scripts from stdin (using the command 'jeql -stdin')
Language Syntax & Semantics
- Allowed expressions to be used in LIMIT and OFFSET clauses
Standard Library
- Added Proj functions for coordinate system reprojection
- Added prj: parameter to ShapefileWriter
- Added KMLReader
- Some Readers now support reading from URL sources (in particular, KMLReader)
- Added support to KMLWriter for writing KMZ files
Version 0.7
Release Date: January 14, 2009
Functionality Improvements
Language Syntax & Semantics
- Can now use select expressions as command parameter arguments
- Changed default formatting of Dates to allow easy sorting
- Changed default formatting of Double values to display more digits of precision
Standard Library
- Added split function Geom.splitByVertices
- Added split function SplitBy.index
- Added aggregate function Agg.geomConnect
- Enhanced KMLWriter to allow styling directly in feature table
- Added DbReader, DbMetadata, DbWriter, DbExec, PostgisReader
- Fixed CSVReader to allow ignoring, skipping or using column names from file
- Added Plot command
Syntax Changes
- table value syntax now does not separate rows with commas (commas are allowed but deprecated)
- table value can be used as an expression term
- Added syntax for WKT constants (such as POINT (...), LINESTRING (...), POLYGON(...) )
Version 0.6.1
Release Date: Sep 15, 2008
Functionality Changes
- ShapefileWriter now outputs SHX file as per Shapefile specification
Version 0.6
Release Date: Aug 5, 2008
Functionality Improvements
- Added EXCEPT modifier to starred-table references in select result-list
- Added support for Date datatype (Date function class, etc)
Functionality Changes
- Print command provides a clean output format (but provides code: parameter for JEQL code format)
- imports can now override previously registered classes
Version 0.5
Release Date: July 20, 2008
Functionality Improvements
- Added DbfReader
- Added Geom.nearestPoints()
- Added Geom.numInteriorRings()
- Added Geom.exteriorRing()
- Added RegEx function class
- Improved error reporting for unknown commands
- Enhanced KMLWriter with better default behaviours, new styling elements
- Added Raw String and Rich String literal syntax
- Added SPLIT BY clause, splitValue, splitIndex pseudo-columns
- Added Geom.splitByMembers(), String.splitByString() splitting functions
- Added Memorize command
- Added Polygonizer command
Bug Fixes
- Fixed TextWriter and CSVWriter to use platform-specific line separator
- Fixed evaluation of operators with null operands
- Fixed ShapefileWriter to handle empty tables (writes shapefile with POINT geometry type)
- Fixed ShapefileWriter to handle empty polygons correctly
- Fixed aggregated queries to handle empty input tables
- No longer requires variables to be defined before being used as command output arguments
Samples & Unit Tests
- Added testShapefile.jql
- Added testRegEx.jql
- Added testTypes.jql
API Changes
- Changed KMLWriter feature table columns