fix aggregate func args, convert function in MySQL, support drop index and key, like params

What's Changed

• feat: support execute stmt in pg by @taozhi8833998 in #1552
• feat: support for loop stmt in pg by @taozhi8833998 in #1554
• refactor: update pg definition by @taozhi8833998 in #1555
• fix: on update now() in mysql by @taozhi8833998 in #1557
• fix: keep origin quote string type by @taozhi8833998 in #1560
• feat: support accentuated characters in pg by @taozhi8833998 in #1570
• fix: support order by for column in create constaint in mysql by @taozhi8833998 in #1572
• fix: support keyword as column name in create table sql in sqlite by @taozhi8833998 in #1576
• fix: sqlify to mariadb for autoincrement from sqlite by @taozhi8833998 in #1578
• fix: primary key missing when have unique in sqlify by @taozhi8833998 in #1581
• fix: character varying as data type in pg by @taozhi8833998 in #1584
• fix: sqlify from mariadb ast to sqlite by @taozhi8833998 in #1585
• refactor: update pg definition by @taozhi8833998 in #1589
• refactor: upgrade version by @taozhi8833998 in #1590
• fix: datatype length missing parentheses in all db by @taozhi8833998 in #1602
• fix: join multiple tables in mysql by @taozhi8833998 in #1603
• refactor: support real in sqlite by @taozhi8833998 in #1610
• fix: convert fun in mysql by @taozhi8833998 in #1612
• feat: support checksum and delay_key_write table option in create table by @taozhi8833998 in #1613
• select requires := for assignment, otherwise its a binary operator by @jim-lake in #1616
• allow db prefix in column_refs by @jim-lake in #1605
• refactor: ast be object when single sql, to be array when multiple statements for all db by @taozhi8833998 in #1615
• Feat db prefix column mysql by @taozhi8833998 in #1618
• fix: add more extract field in mysql by @taozhi8833998 in #1621
• fix: extract filed bug in bigquery by @taozhi8833998 in #1626
• feat: support exec stmt without parameters by @WillyWangCn in #1630
• Fix sqlify column snowflake by @taozhi8833998 in #1633
• fix: create table failed in bigquery by @taozhi8833998 in #1637
• fix: column type definition by @taozhi8833998 in #1639
• support all interval types by @jim-lake in #1643
• fix: table name starts with number or lodash in mysql by @taozhi8833998 in #1646
• feat: support show create event, trigger and procedure in mysql by @taozhi8833998 in #1647
• support ignore in insert set by @jim-lake in #1649
• feat: support insert ignore into in mysql by @taozhi8833998 in #1651
• fix: inner join in mssql by @taozhi8833998 in #1654
• feat: support create table in bigquery by @taozhi8833998 in #1655
• fix: set column name can be reserved word by @taozhi8833998 in #1660
• fix unary operation by @jim-lake in #1664
• feat: add unary operator in binary expr in mysql by @taozhi8833998 in #1663
• feat: support like param in mysql by @taozhi8833998 in #1667
• refactor: format unary by @taozhi8833998 in #1668
• refactor: update type for where field by @taozhi8833998 in #1675
• drop index support in alter command by @jim-lake in #1679
• feat: support drop index and key in mysql by @taozhi8833998 in #1681
• fix: aggreate should throw error when args is not right in mysql by @taozhi8833998 in #1684
• feat: add double precision type in pg by @taozhi8833998 in #1687

New Contributors

• @jim-lake made their first contribution in #1616
• @WillyWangCn made their first contribution in #1630

Full Changelog: 4.11.0...4.12.0