0.7.0 Release Notes and 0.8 Goals

[joocer]

What's Changed

• ✨ implement constant exchange optimization  #629 Evaluate constants in expressions during optimization by @joocer in #629 Evaluate constants in expressions during optimization #651
• 🪲 LIKE statement can't follow FOR #653 LIKE and FOR in SHOW statements by @joocer in #653 LIKE and FOR in SHOW statements #654
• ✨ SHOW STORES #439 SHOW STORES by @joocer in #439 SHOW STORES #656
• test-coverage by @joocer in test-coverage #658
• ✨ Support position #542 Support POSITION by @joocer in #542 Support POSITION #660
• ✨ support CASE statements  #22 CASE statements by @joocer in #22 CASE statements #663
• Update sqlparser requirement from 0.26.0 to 0.27.0 by @dependabot in Update sqlparser requirement from 0.26.0 to 0.27.0 #662
• Fix/🪲 CASE statements format ugly #664 by @joocer in Fix/#664 #666
• ✨ Support ARRAY_AGG #665 ARRAY_AGG by @joocer in #665 ARRAY_AGG #672
• ✨ query Optimizer should replace current_date etc as constant exchange  #668 preevaluate fixed-outcome functions by @joocer in #668 preevaluate fixed-outcome functions #674
• TESTS by @joocer in TESTS #675
• 🪲 Nested function failure #670 by @joocer in #670 #676
• 🪲 COUNT(*) doesn't work on aggregates without GROUP BY #669 COUNT(*) cannot be mixed with other aggregates. by @joocer in #669 COUNT(*) cannot be mixed with other aggregates. #677
• ✨ Support AST TRIM function #300 Extended TRIM syntax by @joocer in #300 Extended TRIM syntax #680
• 🪲 GROUP BY incorrect behaviour  #518 by @joocer in #518 #681
• ✨ Implement logical equivalence optimizations #570 De Morgans Laws by @joocer in #570 De Morgans Laws #682
• Tests 02 by @joocer in Tests 02 #686
• 🪲Error in evaluation code (optimizer disabled) #689 by @joocer in #689 #690
• 🚀 Version 0.7.0 #691 by @joocer in #691 #692

New Contributors

• @dependabot made their first contribution in Update sqlparser requirement from 0.26.0 to 0.27.0 #662

Full Changelog: 0.6.0...0.7.0

---

This discussion was created from the release 0.7.0.