SQL Building

This section explains all about the various syntax elements involved with SqliteMagic's SQL building capabilities.

• TheSELECT Clause
• The FROM Clause
• The JOIN Clause
• The WHERE Clause
• The GROUP BY Clause
• The HAVING Clause
• The ORDER BY Clause
• The LIMIT .. OFFSET Clause
• Generated Tables
• Aliased Tables
• Nested Selects
• Column Expressions
• Conditional Expressions