0.3 unstable SQL Abstract Syntax Trees Vocabulary A vocabulary that allows SQL code abstract syntax trees to be published in RDF. 2013-12-09 2014-01-28 SQL Abstract Syntax Trees Vocabulary Corentin Follenfant Olivier Corby sql http://ns.inria.fr/ast/sql# Generic AST Node Abstract class subsumed by all AST node classes. Predicate Represents a collection of one or more expressions or subqueries, that may be combined with logical operators, and when evaluated returns one of the TRUE / FALSE / UNKNOWN truth values. Join Predicate Binary predicate used join two or more tables. Cross Join Predicate Join predicate used to perform the cross-product of two tables. Inner Join Predicate Outer Join Predicate Right Outer Join Predicate Left Outer Join Predicate Full Outer Join Predicate Is Null predicate Unary predicate that compares the evaluated expression's value with NULL Range predicate Ternary predicate used to assert whether a provided expression's value is within the range specified by two other expressions' values. In predicate Variadic predicate used to assert whether the first provided expression's value is within the set of following provided expressions' values. Exists predicate Unary predicate that returns one of the TRUE or FALSE truth values depending on whether the evaluated subquery returns an empty result set. Like predicate Binary predicate that returns one of the TRUE or FALSE truth values depending on whether the string resulting in the evaluation of the first expression matches the lightweight regular expression described in the second expression. Operator A SQL operator used to perform arithmetic calculations, comparisons or value assignments. Alias The SQL AS operator used to give an identifier to an expression. All The SQL '*' wildcard operator, substitutes to all the columns of the tables in the FROM clause. Arithmetic Operator A SQL arithmetic operator used to perform arithmetic calculation. Negation A unary arithmetic operator used to produce the negative of its operand. Addition Subtraction Multiplication Division Comparison Operator A binary operator used to compare two values, and when evaluated returns one of the TRUE / FALSE / UNKNOWN truth values. Greater than comparison Less than comparison Equality comparison Difference comparison Greater than or equal to comparison Less than or equal to comparison Logical Operator A SQL logical connective used to perform logical calculation. Logical Conjunction Logical Disjunction Logical Negation A SQL logical negation that can be used to negate any condition. Set Operator A SQL set operator used to perform set operation on the results of two or more queries. Union A SQL union operator used to return the combination of the result sets of two or more queries. Union All A SQL union operator used to return the combination of the result sets of two or more queries, including duplicate result rows. Intersection A SQL intersection operator used to return the common result rows of the combination of the result sets of two or more queries. Exclusion A SQL exclusion operator used to return the result set produced by removing the result rows of the second query that appear in the result set of the first query. String Operator Concatenation A SQL concatenation operator that returns the combination of two strings, expressions or values. Expression A SQL expression denotes any clause that when evaluated returns values. Case Expression A SQL case expression enables the use of the IF <condition> THEN <consequent> ELSE <alternative> logic within SQL statements. Function Expression A SQL function expressions consists in the use of any built-in SQL function. Aggregation Expression A SQL aggregation expression consists in the use of an aggregate function. Function A SQL built-in function that performs calculation and returns a value. May be vendor-specific. Scalar Function A SQL scalar function returns a single value given the input values. The input value is of a SQL primitive data type. Aggregate Function A SQL aggregate function returns a single value given the values of multiple rows from a column. Sum The SQL aggregate function that returns the sum of the given expression. Average The SQL aggregate function that returns the mean of the given expression. Count The SQL aggregate function that returns the number of rows or non NULL values from the result set. Minimum The SQL aggregate function that returns the minimum value of the given expression. Maximum The SQL aggregate function that returns the maximum value of the given expression. Variance The SQL aggregate function that returns the variance of the given expression. Standard Deviation The SQL aggregate function that returns the standard deviation (square root of the variance) of the given expression. Data Type Conversion Function A SQL scalar function. Cast A SQL scalar function that converts an expression to a target data type Date Time Computation Function A SQL date time function returns a date or time value or performs a specific date or time value computation. Now A SQL now function is a nullary function that returns the current timestamp. Table Function A SQL function that returns a virtual table. Number Function A SQL number function that returns a numeric value and reads numeric values or string with numeric characters. Statement A SQL statement. Data Definition Statement A SQL data definition statement. Data Manipulation Statement A SQL data manipulation statement. Procedural Statement A SQL procedural statement. Transaction Management Statement A SQL transaction management statement. Session Management Statement A SQL session management statement. Access Control Statement A SQL access control statement. Import / Export Statement A SQL import or export statement. Alter Statement A SQL ALTER statement. Create Statement A SQL CREATE statement. Drop Statement A SQL DROP statement. Select Statement A SQL SELECT statement. Insert Statement A SQL INSERT statement. Delete Statement A SQL DELETE statement. Update Statement A SQL UPDATE statement. Call Statement A SQL CALL statement. Commit Statement A SQL COMMIT statement. Rollback Statement A SQL ROLLBACK statement. Lock Table Statement A SQL LOCK TABLE statement. Connect Statement A SQL CONNECT statement. Set Statement Assigns a value to a session variable identifier. Grant Statement A SQL GRANT statement used to give a set of privileges or roles to specified users that are actionable on specified database objects. Revoke Statement A SQL REVOKE statement used to revoke a set of privileges or roles to specified users from specified database objects. AST Node Arguments The generic predicate used to attach an ordered list of children to any AST node. Clause A SQL clause is a part of a statement. SELECT clause The SQL clause that specifies the projected tables of a SELECT statement. FROM clause The SQL clause that specifies the target sources (tables, views, subqueries) of a SELECT statement. WHERE clause The SQL clause that specifies the filtering predicates to apply on the inputs of the FROM clause. GROUP BY clause The SQL clause that specifies the columns whose values will be considered to cluster the result set of selected rows. HAVING clause The SQL clause that specifies the filtering predicates to apply on the clustered result set resulting of a GROUP BY clause. ORDER BY clause The SQL clause that specifies how to order the result set's records according to given expressions. LIMIT clause The SQL clause that limits the number of records from the result set that should be returned. INTO target table clause The SQL clause that specifies into which table the following values or select statement's result set are to be inserted into. VALUES list Clause The SQL clause that specifies a list of values or expressions evaluating to values. Database Catalog Object A database catalog object reference. Relational Schema A reference or declarative statement for a catalog schema. Relational Table A reference or declarative statement for a catalog table. Relational Column A reference or declarative statement for a catalog column. Relational Index A reference or declarative statement for a catalog index. Relational Procedure A reference or declarative statement for a catalog procedure. Relational User A reference or declarative statement for a catalog user. Relational Role A reference or declarative statement for a catalog role. Relational View A reference or declarative statement for a catalog view. Relational Sequence A reference or declarative statement for a catalog sequence. Database Catalog Object Identifier A database catalog object identifier, qualified or not. Schema Identifier A valid identifier for a catalog schema. Table Identifier A valid identifier for a catalog table. Column Identifier A valid identifier for a catalog column. Index Identifier A valid identifier for a catalog index. Procedure Identifier A valid identifier for a catalog procedure. User Identifier A valid identifier for a catalog user. Role Identifier A valid identifier for a catalog role. View Identifier A valid identifier for a catalog view. Identifier A valid identifier for a catalog sequence.