JSQL

readme

as group by order by pagination sql functions union where

ingesting data installation security setup syntax writing queries

delete insert into reset select update

What is JSQL?

JSQL is a JavaScript library built to provide access to the browsers IndexedDB database using SQL query strings.

What is SQL?

SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can JSQL do?

JSQL can execute queries against a database
JSQL can retrieve data from a database
JSQL can insert records in a database
JSQL can update records in a database
JSQL can delete records from a database
JSQL can create new databases
JSQL can create new tables in a database

SQL is a Standard BUT....

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. To be compliant with the ANSI standard, we support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, and WHERE) in a similar manner.