sql

AlaSQL SQL Statements

• [Single and multiple SQL statements](Multiple Statements)
• [Standard](Standard Interface) and [fluent (like LINQ)](Fluent Interface) interface
• Literals
• [Case-sensitive keywords](Case Sensitive)
• Comments
• [Data types](Data types)

Short list by category

Data query

• SELECT - for relational data
• SEARCH - for nested JSON objects

Expression statement

• [= Expression Statement](Expression Statement)

Data manipulation

• INSERT, [INSERT OR REPLACE](Insert Or Replace), [REPLACE](Insert Or Replace)
• UPDATE
• DELETE

Data definition

• [CREATE TABLE](Create Table)
• [ALTER TABLE](Alter Table)
• [DROP TABLE](Drop Table)
• [CREATE VIEW](Create View)
• [DROP VIEW](Drop View)

Database

• [USE DATABASE](Use Database)
• [CREATE DATABASE](Create Database)
• [DROP DATABASE](Drop Database)

External database

• [ATTACH DATABASE](Attach Database)
• [DETACH DATABASE](Detach Database)

Transactions

• [BEGIN TRANSACTION](Begin Transaction)
• [COMMIT TRANSACTION](Commit Transaction)
• ROLLBACK TRANSACTION

Show

• [SHOW DATABASES](Show Databases)
• [SHOW TABLES](Show Tables)
• [SHOW CREATE TABLE](Show Create Table)

Program

• DECLARE
• SET
• [IF THEN](If Then Else), [IF THEN ELSE](If Then Else)
• [BEGIN END](Begin End)
• WHILE
• SOURCE

Debug

• ASSERT

Information

• HELP

Full list

• ASSERT

• ATTACH

• ALTER TABLE

• [ALTER TABLE ADD COLUMN](Add Column)

• [ALTER TABLE MODIFY COLUMN](Modify Column)

• [ALTER TABLE DROP COLUMN](Drop Column)

• [ALTER TABLE RENAME TABLE](Rename Table)

• [BEGIN TRANSACTION](Begin Transaction)

• [COMMIT TRANSACTION](Commit Transaction)

• CREATE

• [CREATE DATABASE](Create Database)

• [CREATE TABLE](Create Table)

• Column Types

  • JavaScript data types
    • String
    • Number
    • Boolean
    • Date and ISODate
      • Emun
  • ANSI SQL types
  • SQLite, Oracle, MySQL, SQL Server, Postgres data types mapping

• Column constraints

  • [PRIMARY KEY](Primary Key)
  • [FOREIGN KEY](Foreign Key)
  • DEFAULT
  • NULL / [NOT NULL](Not Null)
  • AUTO_INCREMENT, AUTOINCREMENT, IDENTITY
  • CHECK

• [CREATE TRIGGER](Create Trigger)

• [CREATE GRAPH](Create Graph)

• [CREATE EDGE](Create Edge)

• [CREATE VERTEX](Create Vertex)

• DELETE

• DROP

• [DROP DATABASE](Drop Database)

• [DROP TABLE](Drop Table)

• [DROP TRIGGER](Drop Trigger)

• INSERT

• [INSERT SELECT](Insert Select)

• [INSERT VALUES](Insert Values)

• [INSERT DEFAULT VALUES](Insert Default Values)

• [RENAME TABLE](Rename Table)

• [ROLLBACK TRANSACTION](Rollback Transaction)

• SELECT

• TOP

• DISTINCT

• INTO

• FROM

• JOIN

• [GROUP BY](Group By)

• HAVING

• [ORDER BY](Order By)

• LIMIT

• OFFSET

• UNION

• [UNION ALL](Union All)

• INTERSECT

• Minus,EXCEPT

• SHOW

• [SHOW CREATE TABLE](Show Create Table)

• [SHOW COLUMNS](Show Columns)

• [SHOW DATABASES](Show Databases)

• [SHOW TABLES](Show Tables)

• UPDATE

• [USE DATABASE](Use Database)

• Operators

• Number

• • • • / %

• String

• Comparing

• = != < <= > >=

• BETWEEN, [NOT BETWEEN](Not Between)

• NULL

  • [IS NULL](Is Null), [IS NOT NULL](Is Not Null), [NOT NULL](Is Not Null)

• Inclusion

  • IN, [NOT IN](Not In), CONTAINS

• SQL-Functions

• ABS()

• [Custom functions](Custom Functions)

• Complex Operators

  • EXISTS, [NOT EXISTS](Not Exists)
  • IN, [NOT IN](Not In)
  • SOME, ANY
  • ALL

• Aggregators

• SUM()

• COUNT()

• MIN()

• MAX()

• FIRST()

• LAST()

• MEDIAN()

• AGGR()

• ARRAY()

• [Statistical functions](Statistical Functions)

• [Custom aggregators](Custom Aggregators)

• Grouping functions

• CUBE()

• ROLLUP()

• [GROUPING SETS()](Grouping Sets)

• Standard functions

• Subqueries / Sub SELECT operator

• [User-defined SQL functions](User Defined Functions)

• Type conversions

• CAST

• CONVERT

• FORMAT

• [:: double-colon](Double Colon)