Expressions

[wbijker]

SqlExpressions are the basic building blocks to construct a query. It is the job of the SqlDriver to make the actual translation to SQL and execute against the database.

Basic four types of queries: Select, Update, Insert and Delete.

SELECT [SqlExpression] FROM [SqlSource] WHERE [BooleanSqlExpression] ([SqlExpression operator [SqlExpression]) ORDER BY [SqlExpression] GROUP BY [SqlExpression]*

UPDATE [SqlTable] SET [SqlColumn] = [SqlExpression] WHERE [BooleanSqlExpression]

INSERT INTO [SqlTable] ([SqlColumn]*) VALUES ([SqlExpression])

DELETE FROM [SqlTable] WHERE [BooleanSqlExpression]

[wbijker]

ConstantSqlExpression LikeSqlExpression CastSqlExpression ColumnSqlExpression AggregateSqlExpression RowSqlExpression FunctionSqlExpression MathSqlExpression BooleanSqlExpression