Chapter 31. GDBase Command Reference

Table of Contents

Introduction
ALTER TABLE
CHECK TABLE
COMMENT
CREATE INDEX
CREATE/REPLACE TABLE
CREATE TABLE ... TRANSFORM
The __vars__ dictionary
Skipping rows
Processing in groups
The __save__ function
Referring to previous rows
Using sql inside TRANSFORM
CREATE TRIGGER
The RAISE function
CREATE VIEW
DELETE
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
GET
INSERT
MERGE
ON CONFLICT
REPLACE INTO
SELECT
DISTINCT
KEEP and DROP
FROM
WHERE
GROUP BY
ORDER BY
LIMIT
UNION, UNION ALL, APPEND, EXCEPT, INTERSECT
JOIN
SAMPLE
Order of execution in SELECT statements
TRANSACTION
UPDATE
Data types
Expressions
Unary operators
Binary operators
Column names
SELECT statement in expressions
CAST statement
Additional information
GDBase core functions
Simple functions
Aggregate Functions
Window functions
Quoting
GDBase keywords
Special characters
Nulls handling
Comments in SQL code

Introduction

GDBase understands most of the standard SQL language. However, it omits some features while at the same time adding a few features of its own. This document attempts to describe precisely what parts of the SQL language GDBase does or does not support.

In all of the syntax diagrams that follow, literal text is shown in bold. Non-terminal symbols are shown in italic. Operators that are part of the syntactic markup itself are shown in black roman.

GDBase supports the following commands:

Details on the implementation of each command are provided in the sections below.

A unique feature of GDBase is its ability to use Gython code to process data. This functionality is described in the CREATE TABLE ... TRANSFORM section of this chapter.

The construction of expressions used in queries and other operations is described in the Expressions section.

The built-in string, numeric, date and time, and aggregate functions are described in the Core Functions section.