Andrey Gershun edited this page Jan 8, 2016 · 30 revisions

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

Debug

Information

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

  • [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

  • SQL-Functions

  • ABS()

  • [Custom functions](Custom Functions)

  • Complex Operators

  • 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)

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.