SQL statements

Top-level SQL statement builders: SELECT, INSERT, UPDATE, DELETE, WITH, JOIN, and set operations (UNION/INTERSECT/EXCEPT). More...

Classes
class	iron_query::DeleteFrom
	Transitional representation for DELETE FROM query. More...
class	iron_query::InsertInto
	Transitional representation for INSERT INTO query. More...
struct	iron_query::JoinKind
	Kind of SQL JOIN, e.g. Inner or LeftOuter. More...
class	iron_query::Join
	Transitional representation for JOIN query. More...
class	iron_query::SelectExpr
	Transitional representation for SELECT query. More...
struct	iron_query::SetOpKind
	Kind of SQL set operation, e.g. Union or Except. More...
class	iron_query::SetOp
	Transitional representation for UNION/UNION ALL/INTERSECT/EXCEPT. More...
class	iron_query::Update
	Transitional representation for UPDATE query. More...
class	iron_query::WithQuery
	Finalized WITH ... query, usable anywhere a VirtualTable is (subquery, FROM source, etc.) More...
class	iron_query::WithBuilder
	Transitional representation for a WITH clause being built up. More...

Functions
SelectExpr	iron_query::From (const VirtualTable &tbl)
	Handy fabric for SelectExpr.
WithBuilder	iron_query::With (std::string name, const VirtualTable &query)
	Handy fabric for WithBuilder. name must be a valid (optionally dotted) SQL identifier.

Detailed Description

Top-level SQL statement builders: SELECT, INSERT, UPDATE, DELETE, WITH, JOIN, and set operations (UNION/INTERSECT/EXCEPT).

Function Documentation

With()

WithBuilder iron_query::With	(	std::string	name,
		const VirtualTable &	query
	)

Handy fabric for WithBuilder. name must be a valid (optionally dotted) SQL identifier.

Exceptions

InvalidIdentifier

if name is not a valid identifier.