Opteryx

What's Changed
* Donate by joocer in https://github.com/mabel-dev/opteryx/pull/695
* Update FUNDING.yml by joocer in https://github.com/mabel-dev/opteryx/pull/696
* 515 by joocer in https://github.com/mabel-dev/opteryx/pull/697
* 515 by joocer in https://github.com/mabel-dev/opteryx/pull/701
* 703 by joocer in https://github.com/mabel-dev/opteryx/pull/704
* 19 Initial CTE implementation by joocer in https://github.com/mabel-dev/opteryx/pull/706
* 204 by joocer in https://github.com/mabel-dev/opteryx/pull/709
* 712 by joocer in https://github.com/mabel-dev/opteryx/pull/714
* 204 by joocer in https://github.com/mabel-dev/opteryx/pull/715
* 716 by joocer in https://github.com/mabel-dev/opteryx/pull/717
* 713 by joocer in https://github.com/mabel-dev/opteryx/pull/718
* 711 by joocer in https://github.com/mabel-dev/opteryx/pull/719
* 708 by joocer in https://github.com/mabel-dev/opteryx/pull/726
* Update sqlparser requirement from 0.27.0 to 0.28.0 by dependabot in https://github.com/mabel-dev/opteryx/pull/720
* 634 by joocer in https://github.com/mabel-dev/opteryx/pull/732
* 722 by joocer in https://github.com/mabel-dev/opteryx/pull/733
* 721 by joocer in https://github.com/mabel-dev/opteryx/pull/734
* 713 by joocer in https://github.com/mabel-dev/opteryx/pull/737
* 740 by joocer in https://github.com/mabel-dev/opteryx/pull/741
* 743 by joocer in https://github.com/mabel-dev/opteryx/pull/744
* v0.8.0 by joocer in https://github.com/mabel-dev/opteryx/pull/748


**Full Changelog**: https://github.com/mabel-dev/opteryx/compare/0.7.0...0.8.0

What's Changed
* 629 Evaluate constants in expressions during optimization by joocer in https://github.com/mabel-dev/opteryx/pull/651
* 653 LIKE and FOR in SHOW statements by joocer in https://github.com/mabel-dev/opteryx/pull/654
* 439 `SHOW STORES` by joocer in https://github.com/mabel-dev/opteryx/pull/656
* test-coverage by joocer in https://github.com/mabel-dev/opteryx/pull/658
* 542 Support `POSITION` by joocer in https://github.com/mabel-dev/opteryx/pull/660
* 22 CASE statements by joocer in https://github.com/mabel-dev/opteryx/pull/663
* Update sqlparser requirement from 0.26.0 to 0.27.0 by dependabot in https://github.com/mabel-dev/opteryx/pull/662
* Fix/664 by joocer in https://github.com/mabel-dev/opteryx/pull/666
* 665 `ARRAY_AGG` by joocer in https://github.com/mabel-dev/opteryx/pull/672
* 668 preevaluate fixed-outcome functions by joocer in https://github.com/mabel-dev/opteryx/pull/674
* TESTS by joocer in https://github.com/mabel-dev/opteryx/pull/675
* 670 by joocer in https://github.com/mabel-dev/opteryx/pull/676
* 669 `COUNT(*)` cannot be mixed with other aggregates. by joocer in https://github.com/mabel-dev/opteryx/pull/677
* 300 Extended TRIM syntax by joocer in https://github.com/mabel-dev/opteryx/pull/680
* 518 by joocer in https://github.com/mabel-dev/opteryx/pull/681
* 570 De Morgans Laws by joocer in https://github.com/mabel-dev/opteryx/pull/682
* Tests 02 by joocer in https://github.com/mabel-dev/opteryx/pull/686
* 689 by joocer in https://github.com/mabel-dev/opteryx/pull/690
* 691 by joocer in https://github.com/mabel-dev/opteryx/pull/692

New Contributors
* dependabot made their first contribution in https://github.com/mabel-dev/opteryx/pull/662

**Full Changelog**: https://github.com/mabel-dev/opteryx/compare/0.6.0...0.7.0

What's Changed
* 629 Evaluate constants in expressions during optimization by joocer in https://github.com/mabel-dev/opteryx/pull/651
* 653 LIKE and FOR in SHOW statements by joocer in https://github.com/mabel-dev/opteryx/pull/654
* 439 `SHOW STORES` by joocer in https://github.com/mabel-dev/opteryx/pull/656
* test-coverage by joocer in https://github.com/mabel-dev/opteryx/pull/658
* 542 Support `POSITION` by joocer in https://github.com/mabel-dev/opteryx/pull/660
* 22 CASE statements by joocer in https://github.com/mabel-dev/opteryx/pull/663
* Update sqlparser requirement from 0.26.0 to 0.27.0 by dependabot in https://github.com/mabel-dev/opteryx/pull/662
* Fix/664 by joocer in https://github.com/mabel-dev/opteryx/pull/666
* 665 `ARRAY_AGG` by joocer in https://github.com/mabel-dev/opteryx/pull/672
* 668 preevaluate fixed-outcome functions by joocer in https://github.com/mabel-dev/opteryx/pull/674
* TESTS by joocer in https://github.com/mabel-dev/opteryx/pull/675
* 670 by joocer in https://github.com/mabel-dev/opteryx/pull/676
* 669 `COUNT(*)` cannot be mixed with other aggregates. by joocer in https://github.com/mabel-dev/opteryx/pull/677
* 300 Extended TRIM syntax by joocer in https://github.com/mabel-dev/opteryx/pull/680
* 518 by joocer in https://github.com/mabel-dev/opteryx/pull/681
* 570 De Morgans Laws by joocer in https://github.com/mabel-dev/opteryx/pull/682
* Tests 02 by joocer in https://github.com/mabel-dev/opteryx/pull/686
* 689 by joocer in https://github.com/mabel-dev/opteryx/pull/690

New Contributors
* dependabot made their first contribution in https://github.com/mabel-dev/opteryx/pull/662

**Full Changelog**: https://github.com/mabel-dev/opteryx/compare/0.6.0...0.7.0b6

What's Changed
* 568 Cannot aggregate on literals by joocer in https://github.com/mabel-dev/opteryx/pull/574
* Fix/576 by joocer in https://github.com/mabel-dev/opteryx/pull/582
* 584 page defragmentation by joocer in https://github.com/mabel-dev/opteryx/pull/585
* 579 Change preferred RNG source by joocer in https://github.com/mabel-dev/opteryx/pull/586
* 583 Improve Test Coverage by joocer in https://github.com/mabel-dev/opteryx/pull/587
* 588 Insource sqloxide by joocer in https://github.com/mabel-dev/opteryx/pull/590
* 570 Optimizer by joocer in https://github.com/mabel-dev/opteryx/pull/591
* 592 Date function bugs by joocer in https://github.com/mabel-dev/opteryx/pull/594
* 593 reimplement date_trunc by joocer in https://github.com/mabel-dev/opteryx/pull/598
* 129 `FOR` clauses per relation by joocer in https://github.com/mabel-dev/opteryx/pull/602
* 129 by joocer in https://github.com/mabel-dev/opteryx/pull/603
* Feature/547 by joocer in https://github.com/mabel-dev/opteryx/pull/605
* Fix/565 by joocer in https://github.com/mabel-dev/opteryx/pull/606
* Fix/565 2 by joocer in https://github.com/mabel-dev/opteryx/pull/607
* Update dependabot.yml by joocer in https://github.com/mabel-dev/opteryx/pull/608
* 565 by joocer in https://github.com/mabel-dev/opteryx/pull/609
* FEATURE/588 by joocer in https://github.com/mabel-dev/opteryx/pull/610
* FEATURE/588 by joocer in https://github.com/mabel-dev/opteryx/pull/611
* 588 by joocer in https://github.com/mabel-dev/opteryx/pull/612
* FEATURE/588 by joocer in https://github.com/mabel-dev/opteryx/pull/613
* 614 support SUBSTRING by joocer in https://github.com/mabel-dev/opteryx/pull/616
* 543 typed string notation by joocer in https://github.com/mabel-dev/opteryx/pull/618
* 617 by joocer in https://github.com/mabel-dev/opteryx/pull/621
* 619 by joocer in https://github.com/mabel-dev/opteryx/pull/622
* 619 by joocer in https://github.com/mabel-dev/opteryx/pull/623
* 580 Empty results have no columns by joocer in https://github.com/mabel-dev/opteryx/pull/624
* 515 NULLIF by joocer in https://github.com/mabel-dev/opteryx/pull/625
* 626 by joocer in https://github.com/mabel-dev/opteryx/pull/627
* 547 ARM test suite by joocer in https://github.com/mabel-dev/opteryx/pull/630
* FEATURE/547 by joocer in https://github.com/mabel-dev/opteryx/pull/631
* 547 by joocer in https://github.com/mabel-dev/opteryx/pull/635
* 581 SQL Battery by joocer in https://github.com/mabel-dev/opteryx/pull/637
* 638 by joocer in https://github.com/mabel-dev/opteryx/pull/639
* 548 by joocer in https://github.com/mabel-dev/opteryx/pull/641
* 640 `COUNT(*)` optimization fix by joocer in https://github.com/mabel-dev/opteryx/pull/642
* Chore/636 by joocer in https://github.com/mabel-dev/opteryx/pull/643
* 577 by joocer in https://github.com/mabel-dev/opteryx/pull/644
* 645 Null handling by joocer in https://github.com/mabel-dev/opteryx/pull/647
* FIX/648 by joocer in https://github.com/mabel-dev/opteryx/pull/649
* V0.6.0 by joocer in https://github.com/mabel-dev/opteryx/pull/650


**Full Changelog**: https://github.com/mabel-dev/opteryx/compare/0.5...0.6.0

0.6.0b3e


0.6.0b3d


0.6.0b3c


0.6.0b3b


0.6.0b3a

What's Changed
* 568 Cannot aggregate on literals by joocer in https://github.com/mabel-dev/opteryx/pull/574
* Fix/576 by joocer in https://github.com/mabel-dev/opteryx/pull/582
* 584 page defragmentation by joocer in https://github.com/mabel-dev/opteryx/pull/585
* 579 Change preferred RNG source by joocer in https://github.com/mabel-dev/opteryx/pull/586
* 583 Improve Test Coverage by joocer in https://github.com/mabel-dev/opteryx/pull/587
* 588 Insource sqloxide by joocer in https://github.com/mabel-dev/opteryx/pull/590
* 570 Optimizer by joocer in https://github.com/mabel-dev/opteryx/pull/591
* 592 Date function bugs by joocer in https://github.com/mabel-dev/opteryx/pull/594
* 593 reimplement date_trunc by joocer in https://github.com/mabel-dev/opteryx/pull/598
* 129 `FOR` clauses per relation by joocer in https://github.com/mabel-dev/opteryx/pull/602
* 129 by joocer in https://github.com/mabel-dev/opteryx/pull/603
* Feature/547 by joocer in https://github.com/mabel-dev/opteryx/pull/605
* Fix/565 by joocer in https://github.com/mabel-dev/opteryx/pull/606
* Fix/565 2 by joocer in https://github.com/mabel-dev/opteryx/pull/607
* Update dependabot.yml by joocer in https://github.com/mabel-dev/opteryx/pull/608
* 565 by joocer in https://github.com/mabel-dev/opteryx/pull/609


**Full Changelog**: https://github.com/mabel-dev/opteryx/compare/0.5...0.6.0b3