🌟 CLI - Data migration support

Dump whole schemas and data by generating SQL using --dump {PATH} option

$ gluesql --path ~/glue_data --dump ./dump.sql

-- dump.sql
CREATE TABLE Item (id INT, name TEXT);
CREATE INDEX item_id ON Item (id);
..
INSERT INTO Item VALUES (1, 'Foo'), (2, 'Bar') ..
..

Import database

$ gluesql --path ~/new_data --execute ./dump.sql

What's Changed

• Support the way to migrate whole databse with --dump {PATH} argument (+to_ddl()) by @devgony in https://github.com/gluesql/gluesql/pull/977
• Replace double quote to single quote by @devgony in https://github.com/gluesql/gluesql/pull/988
• Replace TryFrom for AstLiteral => TryFrom for Expr, add more test to dump by @devgony in https://github.com/gluesql/gluesql/pull/990
• Bump cli, core, pkg/rust and test-suite versions to v0.13.1 by @panarch in https://github.com/gluesql/gluesql/pull/991

Full Changelog: https://github.com/gluesql/gluesql/compare/v0.13.0...v0.13.1

🌊 Breaking Changes

🌟 AST Builder

AST Builder is now ready to be used! GlueSQL AST builder provides iterator chaining experience to manipulate data which is similar to array chaining methods or DataFrame syntax. For someone who is already familiar with SQL, then there would be almost no extra learning cost to use GlueSQL AST builder. AST builder accepts various sets of params - not only the expression built by its own expr builder, but also it even accepts raw SQL text and prebuilt ASTs.

e.g.

table("Item")
    .select()
    .join("Category")
    .on(col("Category.id").eq("Item.category_id"))
    .group_by("Item.category_id")
    .having("SUM(Item.price) > 80")
    .project("Category.name AS category")
    .project("SUM(Item.price) AS sum_price")
    .execute(glue)
    .await;

| category | sum_price |------------|-------------| | Meat | 90 | | Drink | 85 |

Usage code examples

SELECT queries INSERT queries UPDATE queries DELETE queries

Related PRs (features)

• Implement hash join support to AST builder @panarch (#916)
• [AST-Builder] Impl Case @ding-young (#910)
• [AST] Support ArrayIndexExpr @ding-young (#880)
• Implement AST builder execute function @panarch (#879)
• [Ast Builder] Implement join expression in select statement @seonghun-dev (#803)
• [AST] Implement to_sql func for OrderByExpr @CEOJINSUNG (#812)
• [AST Builder] Implement to_date and let format function to format date data type @ChobobDev (#858)
• [AST Builder] Implement Lower function @ChobobDev (#853)
• Implement order by ast builder @24seconds (#841)
• [AST builder] Implement To_date and To_timestamp function @ChobobDev (#838)
• [AST Builder] Implement format function @ChobobDev (#836)
• [AST builder] Implement Insert statement @kim-seo-hyun (#802)
• [AST Builder] Implement Alter table statement @ding-young (#813)
• [AST-Builder] Create Table Statement @ding-young (#784)
• [AST Builder] Implement EXISTS Expression @CEOJINSUNG (#790)
• [AST Builder] Implement update Expression @seonghun-dev (#720)
• [AST Builder] Implement Div, Mod Function @seonghun-dev (#760)

Related PRs (improvements)

• Add AST builder integration tests of SELECT, UPDATE, INSERT and DELET… @panarch (#955)
• Update AST builder cast function unit test @zmrdltl (#957)
• Expose AST builder unary_op methods to public, @panarch (#956)
• Rename AST builder ExprNode::not to ExprNode::negate @sa1 (#953)
• Add missing select nodes to ExprNode::InList and QueryNode in AST builder @panarch (#934)
• Simplify ast_builder/ QueryNode codes using decl macro @panarch (#932)
• Add from ProjectNode & QueryNode for InListNode in AST builder, @panarch (#925)
• Update ast-builder function expr params to use Into<..Node> @panarch (#926)
• Update AST builder between & hash_executor to accept different param … @panarch (#923)
• Add ExprNode::subquery, @panarch (#922)
• Add AST builder join nodes to query node conversion support @panarch (#921)
• Add setting table_alias support to AST builder table init function @panarch (#920)
• [AST Builder] Combine in_list and in_subquery into in_list @CEOJINSUNG (#808)
• [AST-Builder] change error message in test functions @ding-young (#800)
• Reformat : change ast builder function format @seonghun-dev (#796)

🚀 Features

📚 New metadata tables - GLUE_TABLES, GLUE_TABLE_COLUMNS and GLUE_INDEXES

gluesql> SELECT * FROM GLUE_TABLES;

| TABLE_NAME | |------------| | Bar | | Foo |

gluesql> SELECT * FROM GLUE_TABLE_COLUMNS;

| TABLE_NAME | COLUMN_NAME | COLUMN_ID | |------------|-------------|-----------| | Bar | id | 1 | | Bar | name | 2 | | Bar | type | 3 | | Foo | id | 1 | | Foo | name | 2 |

gluesql> SELECT * FROM GLUE_INDEXES;

| TABLE_NAME | INDEX_NAME | ORDER | EXPRESSION | UNIQUENESS | |------------|----------------|-------|------------|------------| | Foo | PRIMARY | BOTH | id | TRUE | | Foo | Foo_id_1 | BOTH | id + 1 | FALSE | | Foo | Foo_name_concat | BOTH | name + "_" | FALSE |

• Add support GLUE_INDEXES reserved table which provides all index info @devgony (#935)
• Support Dictionary(Schema) view @devgony (#869)

🧭 ORDER BY enhancements

Support ORDER BY ALIAS clause like below

SELECT column_name AS alias_name FROM Table ORDER BY alias_name DESC

• Currently, it throws [error] value not found: alias_name

Original column_name is still available at ORDER BY clause though SELECT clause uses alias_name

SELECT column_name AS alias_name FROM Table ORDER BY column_name DESC

Support ORDER BY COLUMN_INDEX

SELECT alpha, beta FROM Table ORDER BY 1 DESC

• 1 means the column_index which is first column alpha

Support ORDER BY clause in VALUES list

gluesql> VALUES (1, 'a'), (2, 'b') ORDER BY column1 DESC;
 column1 | column2
---------+---------
       2 | b
       1 | a

Related PRs

• Support ORDER BY ALIAS and COLUMN_INDEX @devgony (#805)
• Support ORDER BY clause in VALUES list @devgony (#730)

📋 ToSql trait for AST which provides AST to SQL text conversion for easier debugging

e.g. ToSql::to_sql from the below AST returns this simple SQL text.

• Generated SQL text

CREATE TABLE Foo (id INT, num INT NULL, name TEXT);

• Input AST

Statement::CreateTable {
    if_not_exists: false,
    name: "Foo".into(),
    columns: vec![
        ColumnDef {
            name: "id".to_owned(),
            data_type: DataType::Int,
            options: vec![]
        },
        ColumnDef {
            name: "num".to_owned(),
            data_type: DataType::Int,
            options: vec![ColumnOptionDef {
                name: None,
                option: ColumnOption::Null
            }]
        },
        ColumnDef {
            name: "name".to_owned(),
            data_type: DataType::Text,
            options: vec![]
        }
    ],
    source: None
}
.to_sql()

Related PRs

• Implement to_sql func for SetExpr, Join @CEOJINSUNG (#898)
• [AST] Implement to_sql func for Query, SetExpr, Select, SelectItem, TableWithJoins, IndexItem, TableFactor, TableAlias @CEOJINSUNG (#860)
• [AST] To_sql for CREATE TABLE, ALTER TABLE @ding-young (#807)
• [AST] to_sql for Function @ding-young (#931)
• [AST] to_sql for STATEMENTS @ding-young (#824)
• [AST] Implement to_sql for INSERT, UPDATE, DELETE @ding-young (#821)

🌳 New datatype and functions

New datatype - UINT8

• [Data] add data type u8 @zmrdltl (#828)

New functions - ASCII, CHR, POSITION, TO_DATE, TO_TIMESTAMP and FORMAT

• Implement ASCII, Chr functions @seonghun-dev (#881)
• Implement function POSITION @zmrdltl (#862)
• Implement str_position function under enum Value @zmrdltl (#875)
• [Function] Implement TO_TIME function and let FORMAT get TIME data type @ChobobDev (#842)
• [Function] Implement TO_DATE and TO_TIMESTAMP function @ChobobDev (#833)
• [Function] Implement FORMAT function @ChobobDev (#818)

📈 CLI enhancements

Support .edit {fileName|None} in CLI @devgony (#871)

1. Open temporary editor with last SQL

$> cargo run
gluesql> .run
[error] Nothing in SQL history to run.
gluesql> SELECT 1, 'a', true

| 1 | 'a' | true | |---|-----|------| | 1 | a | TRUE |

gluesql> .edit

=> open Editor with last command on temporary file like /tmp/Glue_****.sql

-- modify in editor
SELECT 1, 'a', true, 2, 'b'

If you want to fix editor type, run below command on OS

# (optional)
$> export EDITOR=vi

gluesql> .run

| 1 | 'a' | true | 2 | 'b' | |---|-----|------|---|-----| | 1 | a | TRUE | 2 | b |

2. Open editor with physical file

gluesql> .edit foo.sql

-- modify in editor
SELECT 1 AS no, 'In physical file' AS name

gluesql> .execute foo.sql

| no | name | |----|------------------| | 1 | In physical file |

New CLI print options

gluesql> .set tabular OFF
gluesql> .set colsep ,
gluesql> .set colwrap '
gluesql> .set heading OFF
gluesql> VALUES (1, 'a', true), (2, 'b', false)

'1','a','true'
'2','b','false'

• Support CLI options @devgony (#820)

Change default print style to markdown

Set markdown as default print style like below

gluesql> SELECT * FROM (VALUES (1, 'a', true), (2, 'b', false)) AS Sub;

| column1 | column2 | column3 | |---------|---------|---------| | 1 | a | TRUE | | 2 | b | FALSE | (pasted from gluesql directly)

• Replace crate::comfy-table with tabled @devgony (#830)

💡 Improvements

Aggregation

• Support Expr::Case in aggregate module @ever0de (#945)
• Update aggregate functions to support Expr @zmrdltl (#749)

sqlparser-rs upgrades

• Upgrade sqlparser-rs to v0.25 @panarch (#907)
• Upgrade sqlparser-rs to v0.24, migrate Interval from Literal to Expr @panarch (#904)
• Upgrade sqlparser-rs to v0.22 @panarch (#819)
• Migrate sqlparser-rs from 0.18 to 0.19, @panarch (#817)

Tests

• [FIx] add omitted uint8 integration test @ChobobDev (#951)
• Rename showcolumns to show_columns @sa1 (#936)
• Replace plan/join.rs unit tests to use AST builder! @panarch (#929)
• Update test-suite select macros to support raw string literals for labels @panarch (#896)
• [Test Suite] add null test in function position @zmrdltl (#901)
• Update test-suite Tester trait to use Glue struct @panarch (#872)
• Add cli/ print and command modules to code coverage tests @panarch (#866)
• [Test suite] Add insert integration test @kim-seo-hyun (#826)
• [Test Suite] unify order of test arguments @zmrdltl (#816)
• [Test Suite] Change the structure of macros used & the order of arguments @zmrdltl (#804)
• Enhance the coverage of operator.rs @ChobobDev (#783)
• [Test Suite] rearrange error test cases to correct file @zmrdltl (#794)
• [Test Suite] move top level test files to new tester folder @zmrdltl (#792)

Other improvements

• Move Expr::Extract structure to Expr::Function::Extract @zmrdltl (#930)
• Feat : Apply macros in i16 data type @ChobobDev (#940)
• Bump uuid version to 1.2.1 @ever0de (#943)
• Provide unsupported warning for select distinct @sa1 (#942)
• Use decl macro to simplify codes in parser_sql module @sa1 (#937)
• Expose Row to Payload::Select and add Row to core::prelude @panarch (#941)
• Add firefox headless browser test to github action @panarch (#939)
• Remove Option which wraps Row in FilterContext, @panarch (#933)
• Add a new method to Row which finds value by ident, @panarch (#928)
• Add /pkg/rust/data/ to .gitignore @panarch (#927)
• Move Expr::Cast structure to Expr::Function::Cast @zmrdltl (#913)
• Grouping GlueSQL projects into pkg/* per language @ever0de (#917)
• Implement macro that implements TryBinaryOperator, @ever0de (#915)
• Implement Key::to_be_bytes for Decimal variant @panarch (#906)
• Add Send + Sync trait bounds to gluesql::Error::Storage variant @panarch (#903)
• Enable str to string clippy options @ever0de (#900)
• Use variable instead of closure in core/ evaluate function module @ever0de (#892)
• Remove comment @ever0de (#891)
• Update coverage.yml to ignore root examples @panarch (#887)
• Update README.md; add await keyword. @24seconds (#889)
• Add root workspace in members @ever0de (#885)
• Auto Implement GStore, GStoreMut traits @ever0de (#884)
• refactor: remove redundant TableFactor::Series.name @devgony (#878)
• Remove unused comments in core/ ast/mod.rs @panarch (#877)
• Remove Result from core/ table::get_alias return type @panarch (#876)
• refactor: Replace ObjectName with String @devgony (#873)
• [Style]remove unnecessary bracket @ChobobDev (#863)
• Remove deprecated wee_alloc dependency use in gluesql-js/ @panarch (#856)
• [Docs] update README @zmrdltl (#852)
• [Data] modify uint8 to parse sql 'INT(8) UNSIGNED' format to 'UINT8' @zmrdltl (#851)
• [Data] modify int128 to parse sql int(128) format to int128 @zmrdltl (#850)
• [Data] remove data type int64 @zmrdltl (#849)
• [Data] modify int32 to parse sql int(32) format to int32 @zmrdltl (#848)
• [Data] modify int16 to parse sql int(16) format to int16 @zmrdltl (#847)
• [Data] modify int8 to parse sql int(8) format to int8 @zmrdltl (#846)
• Improvement validate_unique function when only PrimaryKey exists @ever0de (#832)
• Simplify root doc comment code example @panarch (#831)
• Small improvement: add clear guide for web example module @24seconds (#797)
• Impl TryFrom<&Value> for usize @devgony (#795)

🐛 Bug Fixes

• Fix test-suite tester::test to properly print expected & found labels @panarch (#949)
• fix: unmatced subquery should return Null (not error) @devgony (#948)
• Fix COUNT aggregate to return 0 not 1 if no rows found @ever0de (#946)
• Fix web/ payload data_type json serialization, @panarch (#938)
• Set default-run to root workspace Cargo.toml @panarch (#888)
• Update core/ chrono dependency version to 0.4.22, specify patch version @panarch (#840)

New Contributors

• @sa1 made their first contribution in https://github.com/gluesql/gluesql/pull/936

Full Changelog: https://github.com/gluesql/gluesql/compare/v0.12.0...v0.13.0

🌊 Breaking Changes

⚡ Store trait changes

1. Store traits no longer require generic T

// v0.11
pub trait Store<T: Debug> { .. }
pub trait StoreMut<T: Debug> where Self: Sized { .. }
pub trait Index<T: Debug> { .. }
pub trait IndexMut<T: Debug> where Self: Sized { .. }

// v0.12
pub trait Store { .. }
pub trait StoreMut where Self: Sized { .. }
pub trait Index { .. }
pub trait IndexMut where Self: Sized { .. }

Related PRs

• Remove generic T from Store, StoreMut and Index traits, @panarch (#589)
• Replace SledStorage generic key T from IVec to data::Key @panarch (#588)
• Replace MemoryStorage Key to core::data::Key, @panarch (#577)

2. Store::fetch_data is newly added, Store trait now requires three methods to implement

pub trait Store {
    async fn fetch_schema(&self, table_name: &str) -> Result<Option<Schema>>;
    async fn fetch_data(&self, table_name: &str, key: &Key) -> Result<Option<Row>>;
    async fn scan_data(&self, table_name: &str) -> Result<RowIter>;
}

Related PR

• Implement primary key support, @panarch (#687)

3. StoreMut trait method renamings - insert_data -> append_data and update_data -> insert_data

pub trait StoreMut where Self: Sized {
    ...
    async fn append_data(..) -> ..;
    async fn insert_data(..) -> ..;
}

Related PR

• Rename StoreMut insert_data & update_data methods, @panarch (#774)

🌐 PRIMARY KEY support

GlueSQL now supports PRIMARY KEY!

CREATE TABLE Allegro (
    id INTEGER PRIMARY KEY,
    name TEXT,
);

more info - test-suite/primary_key

• Implement primary key support, @panarch (#687)
• Update Expr::CompoundIdentifier to have more accurate data format @devgony (#770)
• Update SledStorage key.rs to use IVec::from_iter, not IVec::from @panarch (#765)
• Update SledStorage scan_(indexed)_data key not to contain table prefix, @panarch (#762)
• Update sled-storage::update_data not to return error on not-existing … @panarch (#717)

⚓ New queries support

Select query without table & support SERIES(N)

SELECT 1;
SELECT N FROM SERIES(10);

more info - test-suite/series

• Support SELECT * FROM Series(N) and SELECT 1(without table) @devgony (#733)

VALUES support

VALUES (1, 'a'), (2, 'b');
VALUES (1, 'a'), (2, 'b') LIMIT 1;
VALUES (1, 'a'), (2, 'b') LIMIT 1 OFFSET 1;
SELECT * FROM (VALUES (1, 'a'), (2, 'b')) AS Derived;
SELECT * FROM (VALUES (1, 'a'), (2, 'b')) AS Derived(id, name);
CREATE TABLE TableFromValues AS VALUES (1, 'a', True, Null, Null), (2, 'b', False, 3, Null)

more info - test-suite/values

• Support Derived VALUES @devgony (#731)
• Support CTAV(Create Table As Values) @devgony (#704)
• Enhance Values List to validate column type @devgony (#659)
• Support VALUES List in select module @devgony (#648)

Inline view

SELECT * FROM (SELECT COUNT(*) FROM InnerTable) AS InlineView

more info - test-suite/inline_view

• Support Inline view (FROM clause subquery) @devgony (#523)

💒 New storage - SharedMemoryStorage

Non-persistent storage engine which works in multi-threaded environment

• Implement shared memory storage @ever0de (#500)

🌟 [Alpha Phase] AST Builder

Now, SQL is not the only language supported by GlueSQL! AST Builder generates GlueSQL AST directly from Rust codes.

e.g.

let actual = table("Bar")
    .select()
    .filter(col("id").is_null())
    .group_by("id, (a + name)")
    .build();
let expected = "
    SELECT * FROM Bar
    WHERE id IS NULL
    GROUP BY id, (a + name)
";  

let actual = table("Bar")
    .select()
    .group_by("city")
    .project("city, COUNT(name) as num")
    .build();
let expected = "
    SELECT
      city, COUNT(name) as num
    FROM Bar
    GROUP BY city
";

let actual = table("Person")
    .delete()
    .filter(col("name").is_null())
    .build();
let expected = "DELETE FROM Person WHERE name IS NULL";

more info - core/ AST Builder

Related PRs

• Add in_subquery test case using QueryNode @CEOJINSUNG (#781)
• Add QueryNode enum and test_query function @CEOJINSUNG (#777)
• feat:[#756] implement Ltrim and Rtrim function @ChobobDev (#763)
• [AST Builder] Implement substr Funciton @seonghun-dev (#758)
• [AST Builder] Implement Exp Funciton @seonghun-dev (#753)
• [AST Builder] Implement Lpad, Rpad Funciton @seonghun-dev (#752)
• Implement cast function in AST builder @kim-seo-hyun (#759)
• [AST Builder] Implement Concat Funciton @seonghun-dev (#750)
• [AST Builder] Implement radians, degrees Funciton @seonghun-dev (#755)
• [AST Builder] Implement Repeat Funciton @seonghun-dev (#742)
• [AST Builder] Implement GenerateUuid Funciton @seonghun-dev (#740)
• feat:[#732] Implement Gcd and Lcm function to ast_builder @ChobobDev (#734)
• feat:[#728] Implement Logfunction to ast_builder @ChobobDev (#729)
• feat:[#725] Implement Power and Sqrt function to ast_builder @ChobobDev (#726)
• [AST Builder] Update FunctionNode structure @zmrdltl (#723)
• [AST Builder] Implement InSubquery and QueryNode @CEOJINSUNG (#721)
• [AST Builder] Implement Sign function @kim-seo-hyun (#711)
• [AST Builder] Implement Transaction Statements @ding-young (#709)
• [AST Builder] Implement AST builder InList function @CEOJINSUNG (#697)
• [AST Builder] Implement Index Expr @seonghun-dev (#673)
• [AST Builder] Implement drop_table Expr @seonghun-dev (#695)
• implement now function in ast builder @kim-seo-hyun (#692)
• [AST Builder] Implement show_columns Expr @seonghun-dev (#689)
• Implement AST-builder between expression function @CEOJINSUNG (#672)
• feat(ast_build): implement binary operations (modulo, like, ilike, not_like, not_ilike) @bugoverdose (#686)
• refactor(ast_build): reorder binary_op functions and tests @bugoverdose (#681)
• Implement ln in ast_builder @gimwonbae (#680)
• Implement unary_op (+, -, NOT, !) in ast_builder @ding-young (#669)
• Implement AST-builder extract functions @CEOJINSUNG (#666)
• Implement round function in ast_builder @ding-young (#657)
• [AST Builder] Implement Agggregate function COUNT @zmrdltl (#656)
• Add more expression support to project, @panarch (#655)
• Implement ast_builder binary::gte&lte&or @woojinnn (#654)
• Enhance SelectNode::filter @woojinnn (#653)
• Implement AST-builder log2, log10 function @CEOJINSUNG (#650)
• implement ceil function @jaeyoung0909 (#645)
• feat(ast_builder): Add Agggregate functions @zmrdltl (#635)
• Implement add reverse func in ast_builder @seonghun-dev (#637)
• implement ast_builder/expr/function/{Left, Right} @woojinnn (#626)
• Implements trigonometric functions in ast_builder @nyeong (#627)
• feat(ast_build): implement upper function @ChobobDev (#621)
• feat(ast_build): implement ifnull function @bugoverdose (#620)
• Add floor func in ast_builder @yujong-lee (#616)
• Implement query builder base (AST builder) @panarch (#613)

🚀 Features

CLI updates

• Support .spool FilePath command in CLI @devgony (#748)
• Support .columns TABLE command in CLI @devgony (#736)

New data types

• Add INT(16) data type @yujong-lee (#632)
• Add data type i32 @bearney74 (#608)
• Add BYTEA data type support @panarch (#586)
• Add i128 (int128) data type @bearney74 (#563)

New aggregate function - STDEV & VARIANCE

• Add STDEV aggregate funtion @zmrdltl (#684)
• Support VARIANCE aggregate function & update aggregate test @zmrdltl (#598)
• [Data] Add function sqrt for enum Value @zmrdltl (#675)

New function - IFNULL

• Implement IFNull function @bearney74 (#569)

New statement - SHOW INDEXES FROM {table}

• Add Description column to "show index from table" output @bearney74 (#600)
• Show indexes from table... (resolves issue #520) @bearney74 (#551)

ToSql

• Implement ToSql trait which displays AST as SQL text format @bearney74 (#554)

💡 Improvements

GitHub Action related

• Update rust.yml GitHub Action to handle sled_transaction_timeout_* te… @panarch (#772)
• Remove clippy warning in mac os @24seconds (#715)
• Run github action job parallel @24seconds (#699)
• Update coverage action to use grcov & Coveralls @panarch (#647)
• Simplify github rust action - Run tests & Run examples, @panarch (#594)

Test Suite refactoring

• [Test Suite] Merge use crates into one @zmrdltl (#788)
• [Test Suite] Refactor basic @zmrdltl (#785)
• [Test Suite] delete unneccesary keyword vec!, iter() @zmrdltl (#775)
• [Test Suite] Refactor arithmetic @zmrdltl (#773)
• [Test Suite] Refactor aggregate @zmrdltl (#771)

rust-toolchain & sqlparser-rs migration

• chore:[#700] rust version update @ChobobDev (#724)
• upgrade to Sqlparser 0.18 @bearney74 (#612)
• upgrade to rust 1.61 @bearney74 (#564)
• Update rusttoolchain version to 1.60 and sqlparser-rs to 0.17 @bearney74 (#557)

Other improvements

• Add Update integration test @seonghun-dev (#738)
• Replace bool::then to bool::then_some @panarch (#727)
• import only where you use Duration @ever0de (#722)
• Remove unnecessary Box @ever0de (#716)
• Add DROP TABLE multi object test case in integration test @seonghun-dev (#706)
• Mark flaky test using target_os cfg @24seconds (#702)
• Update aggregate structure @zmrdltl (#698)
• Convert TryInto traits into TryFrom @nyeong (#682)
• Add SharedMemoryStorage to the src documentation comment @kim-seo-hyun (#664)
• Add missing test case in test-suite workspace @ever0de (#649)
• Update data types in README.md @arsenkhy (#644)
• Remove unnecessary Result @ever0de (#622)
• Support Deserialize for Payload @ever0de (#607)
• Migrate cli/ clap-rs version to v3.2.2 @panarch (#606)
• Ambiguous column selection should be detected while joining @MRGRAVITY817 (#583)
• Fix primitive numeric types cast not to panic @bearney74 (#573)
• Specify importing modules explicitly in data/value/into.rs @panarch (#587)
• Use const Dialect in parse_query @ever0de (#584)
• Fix PartialEq between f64 and other numeric types @bearney74 (#585)
• Update ast::DataType enum to use SCREAMING_SNAKE_CASE @bearney74 (#575)
• Use checked_x functions for binary op between i8, i64 and decimal data types not to panic on overflow @bearney74 (#571)
• Replace the to_string macro with the serialize_all macro @ever0de (#565)
• Fix the link in gluesql-js/README.md Webpack example @MRGRAVITY817 (#559)
• Unify GroupKey, HashKey(join) and UniqueKey into a single data::Key s… @panarch (#553)
• Clean up gluesql-js/ build scripts, @panarch (#552)

🐛 Bug Fixes

• Fix CAST into i32 or i64 from numeric literals @bearney74 (#611)
• Fix SledStorage export & import multiple times bug, @panarch (#605)
• Fix gluesql-js build and tests @panarch (#591)
• Fix core translate with metadata feature only @panarch (#590)
• Fix sled_multi_threaded example code with threads of INSERT and SELECT, @ever0de (#580)
• Fix rust clippy gh action to check optional features @panarch (#578)
• Fix modulo binary op to handle zero divisor correctly @bearney74 (#576)
• Fix divide by zero error in data::Value @bearney74 (#572)
• Handle DROP INDEX invalid params @ever0de (#566)
• Fix Glue::execute to run multiple sql query string @ming535 (#562)

👏 New Contributors

• @ming535 made their first contribution in https://github.com/gluesql/gluesql/pull/562
• @yujong-lee made their first contribution in https://github.com/gluesql/gluesql/pull/616
• @bugoverdose made their first contribution in https://github.com/gluesql/gluesql/pull/620
• @woojinnn made their first contribution in https://github.com/gluesql/gluesql/pull/626
• @ChobobDev made their first contribution in https://github.com/gluesql/gluesql/pull/621
• @nyeong made their first contribution in https://github.com/gluesql/gluesql/pull/627
• @seonghun-dev made their first contribution in https://github.com/gluesql/gluesql/pull/637
• @arsenkhy made their first contribution in https://github.com/gluesql/gluesql/pull/644
• @jaeyoung0909 made their first contribution in https://github.com/gluesql/gluesql/pull/645
• @CEOJINSUNG made their first contribution in https://github.com/gluesql/gluesql/pull/650
• @ding-young made their first contribution in https://github.com/gluesql/gluesql/pull/657
• @kim-seo-hyun made their first contribution in https://github.com/gluesql/gluesql/pull/664
• @gimwonbae made their first contribution in https://github.com/gluesql/gluesql/pull/680

Full Changelog: https://github.com/gluesql/gluesql/compare/v0.11.0...v0.12

🌊 Breaking Changes

🌈 GlueSQL.js

JavaScript interface for both web browsers and Node.js
GlueSQL works again in web browsers!

e.g.

import { gluesql } from 'gluesql';

const db = await gluesql();

db.query(`
  CREATE TABLE User (id INTEGER, name TEXT);
  INSERT INTO User VALUES (1, "Hello"), (2, "World");
`);

const [{ rows }] = await db.query('SELECT * FROM User;');
console.log(rows);

More Info

• https://github.com/gluesql/gluesql/tree/main/gluesql-js

Related PRs

• Implement TryFrom between Value and serde_json::Value @panarch (#501)
• GlueSQL.js - support both web browsers and Node.js @panarch (#512)
• Fix gluesql-js/package.json to publish files correctly, @panarch (#543)

🚀 Features

New functions - ABS, SIGN and CONCAT

• Concat function implementation @earney (#521)
• add ABS and SIGN functions @earney (#510)

SHOW COLUMNS

• Implement SHOW COLUMNS @earney (#517)

SledStorage export and import

• Implement SledStorage export & import features @panarch (#547)

CLI - SQL file read-and-execute

• Add support SQL file read-and-execute @pythonbrad (#496)

Other new features

• Implement cast to decimal @earney (#529)
• More numeric binary operations with Decimal @earney (#530)
• Implement hash join executor support @panarch (#494)
• Feature implementation - Unary Factorial operation for (unsigned) INT8 type @MRGRAVITY817 (#477)
• Support limit, offset clause in Insert into values ~ @devgony (#484)
• Update evaluate_stateless to support all existing SQL functions, @panarch (#471)

💡 Improvements

sqlparser-rs migration

• Migrate code from sqlparser v14 to v16 @earney (#542)
• Migrate sqlparser-rs version from v0.13 to v0.14, @panarch (#541)
• Bump up sqlparser crate version from 0.11 to 0.13 @MRGRAVITY817 (#479)

Unit test

• Add unit tests to data/value/into.rs module @pythonbrad (#518)
• Add unit tests for data/value/literal.rs @pythonbrad (#497)

Error handling

• Scalar subquery should throw Error when more than one row returned @devgony (#537)
• Apply better names to numeric binary operation error names #424 @earney (#534)
• cast 255 as int8, should return an error, but returns 127 instead (resolves issue #545) @earney (#546)

Other improvements

• Fix typo (Tripple to Triple) @ever0de (#539)
• Minor improvements @ever0de (#507)
• Bump up toolchain ver. from 1.58 -> 1.59 @MRGRAVITY817 (#502)
• Apply nit code improvements to core/ executor/join module @panarch (#498)
• Simplify lifetime uses in data/literal binary operators @panarch (#495)
• Add macos attributes in gitignore @ever0de (#492)
• Fix typo @ever0de (#490)
• Remove unused generic in IndexMut @ever0de (#488)
• Remove Debug macro from the generic requirements for key @ever0de (#486)
• Bump rust version 1.58 @ever0de (#487)
• Update Join::apply to take the whole table(rows) as a stream iterator @MRGRAVITY817 (#472)

🐛 Bug Fixes

• Fix CLI --execute {file}.sql option to support CRLF line break, @panarch (#519)
• Fix value/ big_endian module to handle negative integers correctly, @panarch (#505)

👏 New Contributors

• @pythonbrad made their first contribution in https://github.com/gluesql/gluesql/pull/496
• @earney made their first contribution in https://github.com/gluesql/gluesql/pull/510

Full Changelog: https://github.com/gluesql/gluesql/compare/v0.10.2...v0.11.0

🐛 Bug Fixes

# Cargo.toml

[dependencies.gluesql]
version = "0.10.2"
default-features = false
features = ["memory-storage"]
# or features = ["sled-storage"]

Configuration above now works. memory-storage or sled-storage features were not working in v0.10.1 and it is fixed in v0.10.2.

• Remove gluesql prefix in dependencies and features @ever0de (#465)
• Fix src/lib.rs doc comment, @panarch (#469)

💡 Improvements

• Add --all-targets to cargo test in github rust action @panarch (#467)
• Support limit, offset clause in Insert into Table Select ~ @devgony (#466)

Full Changelog: https://github.com/gluesql/gluesql/compare/v0.10.1...v0.10.2

🌊 Breaking Changes

🌈 CLI Support

$ cargo install gluesql

• Implement CLI application @panarch (#440)
• Add [[bin]] to Cargo.toml, update cli and storage workspace versions, @panarch (#451)
• Update cli/ clap version to 3.0.1 @panarch (#449)
• Change from cli/target to <general>/target in ignore, @ever0de (#443)

🎉 New Data Types

• INT(8) Add int8 data type @ever0de (#407)
• DECIMAL Adding data type: Decimal @boomkim (#377)

🚀 Features

New Functions - EXTRACT & NOW

• Implementing Extract() & now() Function @simple6192 (#379

CTAS (CREATE TABLE AS SELECT) support

• Support CTAS(Create Table As Select ~) statement @devgony (#414)

Postfix factorial (3! = 6) operator support

• 385 factorial operator @devil-k (#396)

SHOW TABLES & SHOW VERSION

• Add Metadata optional store trait, @panarch (#438)

Convert the entire project code structure to workspace based

• Convert gluesql workspace to root lib-package @ever0de (#446)
• Refactor monorepo @ever0de (#442)

Changes

• Update async-recursion & strum_macros versions @panarch (#460)
• Remove duplicate action @ever0de (#459)
• Apply Serde to MemoryStorage instance and make it public, @panarch (#453)
• Remove sorter cfg feature, support all ORDER BY by default @panarch (#450)
• Repair broken links in README @ever0de (#445)
• Bump rust version to 1.57 @ever0de (#444)
• Move join_columns argument from Join::apply() to Join::new() @MRGRAVITY817 (#441)
• typo edit: bigedian -> bigendian resolves #399 @boomkim (#436)
• Move order_by from query to select @devgony (#435)
• Support arithmetic operations for decimal and null @ever0de (#433)

🐛 Bug Fixes

• Fill in the missing #446 @ever0de (#447)
• Add missing assert macro @ever0de (#434)

Full Changelog: https://github.com/gluesql/gluesql/compare/v0.9.0...v0.10.1

🌊 Breaking Changes

🌈 New Reference Storage - MemoryStorage

Now GlueSQL supports two reference storages - SledStorage and MemoryStorage

• In-memory storage support @panarch (#331)
• Support AlterTable for MemoryStorage @ever0de (#376)

🎉 New Data Types

• UUID - add uuid data type @maruoovv (#360)
• MAP - Add MAP data type and UNWRAP function @panarch (#367)
• LIST - Add LIST data type, @panarch (#370)

✨ New Functions

• SQRT, POWER - Add Sqrt, Power @simple6192 (#312)
• RADIANS, DEGREES, PI - Implement radians, degrees, pi math functions #280 @devil-k (#322)
• LTRIM, RTRIM - Implement Function: LTRIM, RTRIM @devgony (#294)
• REVERSE - [ADD] - reverse function @zmrdltl (#327)
• ASIN, ACOS, ATAN - Add functions: ASIN(), ACOS(), ATAN() @boomkim (#296)
• TRIM - Implement TRIM function - Other features @ever0de (#307)
• SUBSTR - Implement substr function @vbbono (#341)
• LOG - Support function LOG @slhmy (#371)
• REPEAT - Implement REPEAT Function @inhwa1025 (#352)
• UUID - add function random generate uuid value @maruoovv (#372)
• AVG - Support aggregation AVG @zmrdltl (#368)

💡 New Expressions

• % - Implement binary operator modulo % @MRGRAVITY817 (#319)
• ILIKE & NOT ILIKE - Support ILIKE and NOT ILIKE operator @maruoovv (#334)
• XOR - Support binary operator XOR, update data-type Int @zmrdltl (#359)
• CASE - Support conditional function CASE @MRGRAVITY817 (#330)

🚀 Features

• Apply bigdecimal feature (solved issue) @devgony (#380)
• Implement CAST from string to DATE, TIME and TIMESTAMP @No-YE (#375)
• support execute_async @24seconds (#366)
• CAST from string to INTERVAL @devgony (#335)

Changes

• Change tarpaulin version to latest @ever0de (#410)
• Add PartialEq<Literal> for Value unit tests @yellowHSE (#413)
• Add Divide unit tests @jiwon-dev (#408)
• Add literal.rs subtract unit tests @kwon-heejeong (#409)
• add Null unit case tests for literal.rs @hyangmin82 (#412)
• Add literal.rs multiply unit tests @heej-ng (#411)
• Implement prelude pattern to organize userside APIs @MRGRAVITY817 (#388)
• Support unary operator(plus, minus) unit test @zmrdltl (#406)
• Supplement remove static lifetime issue @ever0de (#403)
• Remove 'static lifetime of generic types for GStore @ever0de (#400)
• Implement SledStorage::check_retry wrapper function @ever0de (#392)
• Remove explicit uses of TryFrom & TryInto, @panarch (#397)
• Bump rust version to 1.56 & edition 2021 @ever0de (#395)
• Apply toml formatting @ever0de (#391)
• Fix UUID to Uuid to follow the naming convention of Enums @MRGRAVITY817 (#389)
• Replace eval_to_* func to macro @vbbono (#374)
• 328 replace macros to functions @devil-k (#365)
• Remove AstLiteral use in data/row.rs @panarch (#363)
• Implement implicit null insert. @boomkim (#361)
• Bump rust version to 1.55 stable @ever0de (#358)
• Add MemoryStorage integration tests to reach all storage impl codes @panarch (#355)
• Simplify evaluate module codes by replacing from take(1).. to try_next() @panarch (#347)
• Add Codecov badge on README @MRGRAVITY817 (#343)
• Feature test partial @zmrdltl (#332)
• Apply code coverage test to GitHub Action @MRGRAVITY817 (#326)
• Update math function MOD to use modulo in Evaluated @MRGRAVITY817 (#321)

🐛 Bug Fixes

• Handle do not match columns and values @ever0de (#356)
• [Fix, Update] - Partial_Eq error, unit test @zmrdltl (#353)
• Raise error when column option PRIMARY KEY is used. @heka1024 (#339)

👏 New Contributors

• @simple6192 made their first contribution in https://github.com/gluesql/gluesql/pull/312
• @devil-k made their first contribution in https://github.com/gluesql/gluesql/pull/322
• @zmrdltl made their first contribution in https://github.com/gluesql/gluesql/pull/327
• @boomkim made their first contribution in https://github.com/gluesql/gluesql/pull/296
• @vbbono made their first contribution in https://github.com/gluesql/gluesql/pull/341
• @24seconds made their first contribution in https://github.com/gluesql/gluesql/pull/366
• @slhmy made their first contribution in https://github.com/gluesql/gluesql/pull/371
• @inhwa1025 made their first contribution in https://github.com/gluesql/gluesql/pull/352
• @heej-ng made their first contribution in https://github.com/gluesql/gluesql/pull/411
• @hyangmin82 made their first contribution in https://github.com/gluesql/gluesql/pull/412
• @kwon-heejeong made their first contribution in https://github.com/gluesql/gluesql/pull/409
• @jiwon-dev made their first contribution in https://github.com/gluesql/gluesql/pull/408
• @yellowHSE made their first contribution in https://github.com/gluesql/gluesql/pull/413

Full Changelog: https://github.com/gluesql/gluesql/compare/v0.8.0...v0.9.0

🌊 Breaking Changes

🎉 Transaction Support

GlueSQL now supports "TRANSACTION"! New Transaction store trait with three interface methods: begin, rollback and commit is added. GlueSQL's default storage engine, SledStorage supports MVCC transaction using snapshot based internal data structure.

SledStorage transaction details

• Transaction isolation level is SNAPSHOT ISOLATION or also known as REPEATABLE READ.
• Concurrency support but only a single writer at the same time.
• Read operations are not blocked by other read or write operations. (snapshot based)
• Provides transaction timeout limit functionality.

Merged PRs

• Implement MVCC transaction, @panarch (#257)
• Implement SledStorage transaction timeout support, @panarch (#297)

✨ New Functions

Text Functions

• TRIM, LPAD and RPAD

Math Functions

• FLOOR, CEIL, ROUND, DIV, MOD, GCD, LCM, SIN, COS, TAN, EXP, LN, LOG2 and LOG10.

Merged PRs

• Implement TRIM function @ever0de (#292)
• Add Floor, Ceil, Round Function @tmdgusya (#291)
• Add mathematical functions: DIV(), MOD(). @MRGRAVITY817 (#295)
• Add support for gcd and lcm operator @genieCS (#290)
• Support SIN, COS, TAN functions. @maruoovv (#289)
• Lpad rpad @No-YE (#311)
• Add Exp, Ln, Log2, Log10 @heka1024 (#305)

🚀 Features

• Add support for like operaror @euiko (#252)

📚 Changes

• Resolve clippy error @ever0de (#261)
• Support DivisorShouldNotBeZero error and Remove {number} / {interval} implementations @MRGRAVITY817 (#309)
• Remove PRIMARY KEY uses in test codes @panarch (#315)
• Extend sled_transaction_timeout_ tests timeout duration, @panarch (#316)
• Replace binary op macro to normal function, @panarch (#304)
• Add toolchain file that has version number 1.54 @MRGRAVITY817 (#303)
• Reduce try_self! and try_into! macro uses, @panarch (#302)
• Remove Row from Payload::Select, @panarch (#287)
• Remove unnecessary IntoIterator call syntax @ever0de (#274)
• Replace filter_map and next to find_map @ever0de (#271)
• Chang unreachable code that was being treated as "unwrap" to return unreachable error @ever0de (#270)
• Update deps: sqlparser, rust_decimal, indexmap and tokio @panarch (#263)
• Add --all-targets option to clippy @panarch (#262)
• Remove Boolinator crate dependency, @panarch (#254)

🐛 Bug Fixes

• renew Usage at README.md and Doc: executing multiple queries @devgony (#260)

👏 New Contributors

Welcome and thanks a lot to new contributors!

• @euiko
• @ever0de
• @devgony
• @tmdgusya
• @MRGRAVITY817
• @genieCS
• @maruoovv
• @No-YE
• @heka1024

🌊 Breaking Changes

INDEX support

Now GlueSQL support index! You can manipulate indexes using CREATE INDEX and DROP INDEX queries. Newly added query planner is not that smart enough for now, and it only supports single-expression index.

- This kind of multi-expr index is not supported, yet.
CREATE INDEX idx_test ON TableA (id ASC), (name DESC);

For more details, you can look around index integration tests in here - INDEX - integration tests

ORDER BY support

Sorting by multiple expressions and both ascending & descending orders are all supported. With the feature index, ORDER BY clause can be also indexed. ORDER BY support for non-indexed expressions are supported by optional feature sorter and it is enabled by default. If you consider to use GlueSQL for big data analysis purpose, then it would be better to turn off sorter feature which requires evaluation of all fetched rows for non-indexed ORDER BY clauses.

SELECT * FROM TableA ORDER BY id;
SELECT * FROM TableA ORDER BY id ASC, name DESC;
SELECT * FROM TableA ORDER BY id || name DESC, name;
...

🚀 Features

• Update query planner to find index in subqueries, @panarch (#250)
• Fix sled-storage to read & write less on index sync, @panarch (#247)
• Implement ORDER BY {expr} index support @panarch (#244)
• ORDER BY support @panarch (#243)
• Implement TryFrom<&str> for Interval, @panarch (#239)
• Add more expr support to DEFAULT & INSERT VALUES, @panarch (#236)
• Add index expression validator @panarch (#231)
• Implement basic single expression index, @panarch (#227)
• New AST for execution layer @panarch (#223)

📚 Changes

• Fix Rust GitHub Action to check more feature combinations on clippy &… @panarch (#248)
• Update query planner to find index in multi-expr-based ORDER BY, @panarch (#245)
• Move Box from ast::Function to ast::Expr, @panarch (#241)
• Split ast::Function into Function & Aggregate, @panarch (#240)
• Remove unnecessary error formatting on expr & value types which impl … @panarch (#238)
• Validate default expr @panarch (#237)
• Update executor/limit to use evaluate, @panarch (#235)
• Update dependency versions @panarch (#234)
• Remove evaluate use_empty param, replace to handle in BlendContext @panarch (#233)
• Fix benches/sled_benchmark.rs @panarch (#225)
• Fix glue.rs test code to DROP TABLE at first, @panarch (#224)

🐛 Bug Fixes

• Pass FilterContext to blend, projection in nested select can use oute… @panarch (#249)
• Fix sled-storage to read & write less on index sync, @panarch (#247)
• Apply limit after aggregate & sort finished, @panarch (#246)
• Fix ALTER TABLE DROP COLUMN to remove related indexes @panarch (#232)

🌊 Breaking Changes

New data types! - DATE, TIMESTAMP, TIME and INTERVAL

• Add TIME data type support @panarch (#221)
• Implement INTERVAL data type @panarch (#218)
• Add DATE & TIMESTAMP data type @panarch (#215)

📚 Changes

• Accept more timestamp input forms and add unit tests, @panarch (#222)
• Remove unnecessary unwrap used in Interval codes @panarch (#220)
• Replace value::TryFromLiteral trait to default trait impl, @panarch (#219)
• Fix limit not to scan every row, @panarch (#217)
• Add PartialEq between Value::I64 and Value::F64 @panarch (#216)
• Remove Glue struct insert_vec function @panarch (#214)

🚀 Features

• Merge filter->check_expr function into evaluate @panarch (#208)
• Support binary arithmetic operations between Value::I64 and Value::F64 @panarch (#207)
• Implement text concat operator(||) support, @panarch (#206)

📚 Changes

• Remove implicit CAST from Evaluated to bool, @panarch (#209)
• Update iter-enum to 1 @taiki-e (#205)
• Small cleanups - reduce unwrap(), etc @panarch (#204)
• API: Insert Vec @KyGost (#193)
• Fix codes to be clippy(v0.1.51) clean @panarch (#192)
• Select as string & parse single API @KyGost (#187)
• Remove cargo bench from GitHub Action @panarch (#188)

🐛 Bug Fixes

• Fix CREATE TABLE IF NOT EXISTS not to call insert_schema when existin… @panarch (#185)

🌊 Breaking Changes

• Replace Value::Opt- and Empty to Value::Null! @panarch (#169)

Value is simplified and now it only has 5 types. No more Empty and Opt- prefixed types.

pub enum Value {
    Bool(bool), 
    I64(i64),   
    F64(f64),   
    Str(String),
    Null,       
}          

🚀 Features

• Add validation to CREATE & ALTER TABLE @panarch (#184)

Changes

• Merge Prepared & Execute in execute.rs @KyGost (#167)
• Remove Value::from_data_type, merge to TryFromLiteral trait for Value @panarch (#181)
• Add custom enum Literal, it replaces ast::Value @panarch (#180)
• Remove Value::clone_by, replace to Value::TryFrom @panarch (#172)

Refactoring Evaluated enum

• Apply Cow to Evaluate, remove -Ref types @panarch (#179)
• Add EvaluatedRef to clean Evaluated binary operation codes @panarch (#177)
• Remove Evaluated::StringRef, @panarch (#176)
• Rename AstValue to Literal, @panarch (#170)

🐛 Bug Fixes

• Fix type validation to check all possible branches from INSERT & UPDATE @panarch (#183)
• Remove fake unreachable errors in EvaluateError @panarch (#173)

🚀 Features

• LEFT and RIGHT functions @KyGost (#157)
• Implement CAST function @KyGost (#144)
• Inserting Single Quotes value support @KyGost (#145)
• Add type checking validator @KyGost (#143)
• Add Documentation @KyGost (#137)

Changes

• Add OptStr test case to LOWER & UPPER tests @panarch (#168)
• Migrate sqlparser dep version from v0.6.1 to v0.8.0 @panarch (#160)
• Change literal casting function to return from AstValue to Value, @panarch (#162)
• Update Value->cast to support nullable types, @panarch (#163)
• Add mdbook.yml GitHub Action to automate mdBook deployment @panarch (#158)
• Clean up evaluated.rs with macros @KyGost (#156)
• Split data/value.rs single file module into multiple files @panarch (#154)

🚀 Features

• Implement UNIQUE constraint in CREATE TABLE @silathdiir (#141)
• Allow Binary Operations Between <i64> and <f64> @yejihan-dev (#116)

🔍 Changes

• SledStorage atomic operation support @panarch (#136)

📖 Documentation

• Native English changes to README.md for easier readability @noproto (#138, #139)

🚀 Features

• Update StoreMut mutating data functions to accept multiple items @panarch (#133)

Changes

• Replace Rc<Vec<_>> to Rc<[_]>, make codes clippy clean @panarch (#132)
• Merge multi INSERT statements in tests into a single INSERT @panarch (#134)

🚀 Features

• Added benchmarks @Redblueflame (#123)
• SledStorage Clone functionality @KyGost (#122)
• INSERT INTO SELECT @KyGost (#120)
• Update Store traits not to require std::marker::Send @panarch (#117)

Changes

• Clean up sled_storage implementation codes @panarch (#128)
• Changed parse.rs to parse_sql.rs @Redblueflame (#126)

🌊 Breaking Changes

• Convert store traits to async @panarch (#115)

🚀 Features

• Support Plus(+) and Minus(-) signs in WHERE @yejihan-dev (#111)
• Change Store->fetch_schema interface return type to Option<_>, @panarch (#107)
• Support UPPER & LOWER non-aggregating functions @panarch (#106)
• Rename Payload::Select aliases to labels @panarch (#104)
• Support if not exists for create table and if exist for drop table @leoppro (#68)

🚀 Features

• Projection aliases support for SELECT queries @panarch (#103)
• More expression support in blend @panarch (#99)
• Add aliased projection support - AS keyword, @zhangchunzhong (#98)

Changes

• Remove UnionContext, simplify Context uses @panarch (#100)

🐛 Bug Fixes

• Fix AlterTable to support custom storage implementation properly @panarch (#95)

🚀 Features

• Implement ALTER TABLE - ADD, DROP, RENAME COLUMN & RENAME TABLE @panarch (#92)
• Implement DEFAULT column option support in CREATE TABLE @panarch (#91)
• Remove Unreachable error in Row, replace to controllable error. @panarch (#90)

🐛 Bug Fixes

• Report an error for inserting more values than table columns @silathdiir (#89)

Changes

• Update Cargo.toml default to have all features @panarch (#93)
• Change Store trait insert_data return type @panarch (#86)
• Add doc comments to enum Evaluated @panarch (#85)

Changes

• Return row count instead of rows on Insert @ryanhossain9797 (#71)
• change the behavior about null @leoppro (#67)
• Add cargo fmt to github actions @Atul9 (#54)

🚀 Features

• Implement HAVING support (#12) @panarch (#81)
• Implement GROUP BY (#12) @panarch (#74)
• Add support for Inserting Multiple rows @ryanhossain9797 (#69)
• Add support for EXISTS and NOT EXISTS @ryanhossain9797 (#60)
• filter: support is null and not null expr @leoppro (#59)
• Add support for BETWEEN and NOT BETWEEN @ryanhossain9797 (#56)
• Eval num @panarch (#48)