Update rules from squawk

[froque]

• https://github.com/sbdchd/squawk/blob/master/CHANGELOG.md
• prefer-big-int
  • prefer-big-serial sbdchd/squawk#189
  • add rule prefer-big-int sbdchd/squawk#238
• prefer-timestamptz
  • prefer-timestamptz sbdchd/squawk#227
  • add prefer-timestamptz sbdchd/squawk#230
• prefer-bigint-over-int and prefer-bigint-over-smallint to replace prefer-big-int
  • Split prefer-big-int into int and smallint sbdchd/squawk#273
  • prefer-big-int should have an option to ignore smallint sbdchd/squawk#272
• ban-drop-not-null
  • New rule idea: warn on dropping a not null constraint sbdchd/squawk#282
  • Introduce a new rule that bans dropping NOT NULL constraints sbdchd/squawk#288
• ban-drop-table
  • add rule ban-drop-table sbdchd/squawk#286
• transaction-nesting
  • Introduce a new rule to lint nested transactions sbdchd/squawk#303
• adding-required-field
  • Split out adding-required-field rule from adding-not-nullable-field sbdchd/squawk#301
• ✔️ allow foreign key constraints in create table statements sbdchd/squawk#251
  • Allow foreign key constraints in create table statements #32
• ban-concurrent-index-creation-in-transaction
  • https://github.com/sbdchd/squawk/releases/tag/v0.27.0
• ✔️ ban-truncate-cascade
  • linter: add ban-truncate-cascade rule sbdchd/squawk#453
  • Adds ban-truncate-cascade #48
• ban-uncommitted-transaction
  • linter: add rule ban-uncommitted-transaction sbdchd/squawk#699

[froque]

implementing these rules should fail for this:

❯ git diff
diff --git a/src/test/java/com/premiumminds/sonar/postgres/PostgresSqlSensorTest.java b/src/test/java/com/premiumminds/sonar/postgres/PostgresSqlSensorTest.java
index fb9cf2a..35a25fe 100644
--- a/src/test/java/com/premiumminds/sonar/postgres/PostgresSqlSensorTest.java
+++ b/src/test/java/com/premiumminds/sonar/postgres/PostgresSqlSensorTest.java
@@ -81,7 +81,13 @@ class PostgresSqlSensorTest {
     @Test
     public void testAllRules() {
 
-        createFile(contextTester, "file1.sql", "select 1;");
+        createFile(contextTester, "prefer-bigint-over-int1.sql", "CREATE TABLE IF NOT EXISTS posts (id int generated by default as identity primary key);");
+        createFile(contextTester, "prefer-bigint-over-smallint1.sql", "CREATE TABLE IF NOT EXISTS posts (id smallint generated by default as identity primary key);");
+        createFile(contextTester, "prefer-timestamptz1.sql", "CREATE TABLE IF NOT EXISTS app.users(created_ts timestamp, modified_ts timestamp without time zone);");
+        createFile(contextTester, "ban-drop-not-null1.sql", "ALTER TABLE IF EXISTS foo ALTER COLUMN x DROP NOT NULL;");
+        createFile(contextTester, "ban-drop-table1.sql", "DROP TABLE IF EXISTS foo CASCADE;");
+        createFile(contextTester, "transaction-nesting1.sql", "BEGIN;BEGIN;SELECT 1;COMMIT;");
+        createFile(contextTester, "adding-required-field1.sql", "ALTER TABLE IF EXISTS recipe ADD COLUMN IF NOT EXISTS public boolean NOT NULL;");
 
         PostgresSqlSensor sensor = getPostgresSqlSensor(
                 RULE_PARSE_ERROR,