What’s Changed
Highlights of this release contains a lot of T-SQL dialect improvements (shout out to @jpers36 for most of these!). We also added Spark3 as a new dialect thanks to @R7L208. The complete list of changes are shown below.
🚀 Enhancements
- TSQL: Add rank functions #1725 @jpers36
- Spark3 Dialect Support #1706 @R7L208
- Postgres Array Support #1722 @WittierDinosaur
- Hive: Add LEFT SEMI JOIN support #1718 @fatelei
- MySQL: Change and drop column in alter table #1670 @MontealegreLuis
- Added type hints to some rule files #1616 @ttomasz
- Added Redshift to README #1720 @WittierDinosaur
- Exasol: Fix create table statement #1700 @sti0
- TSQL: Add optional delimiter to SET #1717 @jpers36
- TSQL: Escaped quotes #1715 @jpers36
- TSQL: SELECT INTO #1714 @jpers36
- Postgres: Added support for psql variables #1709 @WittierDinosaur
- TSQL: split location clause out from index clause #1711 @jpers36
- TSQL: Override ANSI HAVING #1707 @jpers36
- TSQL: Add UPDATE STATISTICS #1703 @jpers36
- TSQL: CTAS Option Clause #1705 @jpers36
- TSQL: DECLARE has optional AS #1704 @jpers36
- TSQL: DROP STATISTICS and INDEX #1698 @jpers36
- TSQL: CTAS select can be optionally bracketed #1697 @jpers36
- Exasol: Make function_script_terminator more strict #1696 @sti0
- TSQL distribution index location #1695 @jpers36
- TSQL: allow for non-alphanumeric initial characters in delimited identifiers #1693 @jpers36
- TSQL: allow for semi-colon after BEGIN in a BEGIN/END block #1694 @jpers36
- Exasol: Fix adapter script syntax #1692 @sti0
- TSQL: Basic EXECUTE functionality #1691 @jpers36
- TSQL: Add #, @ to valid identifier characters #1690 @jpers36
- TSQL - add support for Filegroups in table create #1689 @nevado
- Exclude Exasol scripts from rule L003 #1684 @tunetheweb
- Added PostGIS keyword data types to Postgres #1686 @WittierDinosaur
- Indent LIMIT values if on separate line #1683 @tunetheweb
- Postgres: Added support for SELECT INTO statements #1676 @WittierDinosaur
- Allow :: casting of CASE statements #1657 @tunetheweb
- Add more keywords to Redhift and BigQuery to avoid errors #1671 @tunetheweb
- TSQL begin end delimiter #1664 @jpers36
- Teradata: Added date as bare function for #1663 @anzelpwj
- TSQL: CREATE STATISTICS #1662 @jpers36
- TSQL table and query hints #1661 @jpers36
- TSQL: Allow spaces in qualified names #1654 @jpers36
🐛 Bug Fixes
- EXASOL: Fix typo in alter_table_statement #1726 @sti0
- Fix markdown links in production.rst #1721 @asottile
- Correct contributing testing information #1702 @adam-tokarski
- More ORDER BY clarifications #1681 @tunetheweb
- Fix TSQL L025 linter exception #1677 @tunetheweb
- Improve Jinja whitespace handling in rules #1647 @barrywhart