Awesome

The QSI is the pure C# Query Structure Interface.

Languages

Structure Compiler

It compiles the result structure and relation

based on semantic tree transformed by parser's for each language.

Status

Table Features

SELECT 1 AS a, '2' AS b

-- table : id, name
SELECT * FROM table

-- table : id, name
SELECT * FROM
    (SELECT * FROM table) AS alias

-- table : id, name
SELECT * FROM
    (SELECT * FROM table)

-- table : id, name
SELECT * FROM table AS alias(a, b)

SELECT * FROM
    (
        VALUES (1, 2), (3, 4)
    ) AS inline_table(a, b)

-- function : id, name
SELECT * FROM tbl_func('table function')

-- TODO

WITH cte AS (SELECT 1 AS n)
SELECT * FROM cte

WITH cte (n) AS (SELECT 1)
SELECT * FROM cte

WITH RECURSIVE cte AS (
    SELECT 1 AS n
    UNION ALL
    SELECT n + 1 FROM cte WHERE n < 10
)
SELECT * FROM cte

-- left_table : name, uid
-- right_table : age, uid
SELECT * FROM
    left_table l
    JOIN right_table r ON l.uid = r.uid

-- left_table : name, uid
-- right_table : age, uid
SELECT * FROM
    left_table
    JOIN right_table USING (uid)

SELECT a FROM first_table
UNION ALL
SELECT b FROM second_table

-- TODO

-- TODO

-- table_view : a, b
-- table : id, name
SELECT * FROM table_view

-- TODO

-- TODO

-- TODO

Development

Requirements

• PowerShell
• .NET 6.0
• Java >= 1.8

Command

Setup

PowerShell

PS> cd ./qsi
PS> ./Setup.ps1

Terminal

cd ./qsi
./setup.sh

Publish

PS> cd ./qsi
PS> ./Publish.ps1 <VERSION> [-Mode <PUBLISH_MODE>]

• <VERSION>

  Specifies the package version.

  Version must be greater than the latest version tag on git.

• -Mode <PUBLISH_MODE>

  Specifies the publish mode.

  PUBLISH_MODE	Action
  Publish(Default)	Publish packages to NuGet, GitHub repositories
  Local	Publish packages to local repository
  Archive	Build packages to ./qsi/Publish

Debugger

It supports abstract syntax trees and semantic trees, and a debugger that can debug compilation results.

Run

$ cd qsi/Qsi.Debugger
$ dotnet run