SQL Syntax for the JDBC Driver
Supported Syntax
The Digital Event Persistence (DEP) driver for Java Database Connectivity (JDBC) supports the following syntax:
Column lists to specify the columns that the query returns, or
* for all columns.
Aggregate functions such as
count,
sum,
min,
max, and
avg.
Column aliases for renaming columns or assigning a name to an aggregate result in the results.
Grouping of results for aggregate functions.
Ordering of results for instance and aggregate queries.
LIMIT clause for returning the first
n results of a query.
Standard comparison operators for filtering:
=,
!=,
<>,
>,
>=,
<, and
<=.
BETWEEN operator for timestamp, string, and numeric range comparisons.
Logical operations such as
and |
or.
Parentheses
( ) to specify precedence.
Date-based queries for
TIMESTAMP column types.
Syntax Grammar
The following snippet provides an abbreviated grammar for the supported syntax:
SELECT * | column_list, function_list
FROM TABLE table
[WHERE search_condition]
[GROUP BY column_list]
[ORDER BY column_list]
[LIMIT n]
;
Unsupported Syntax and Features
This JDBC driver does not support the following features:
Joins
Nested
SELECT statements
IN and
LIKE operators
INSERT,
UPDATE, and
DELETE In addition, the driver does not support the following digital event field types. These field types do not appear in any of the JDBC metadata APIs and they are not available via query:
Any Array Map