feat!: drop modules, general refactor and cleanup

4 files changed, 462 insertions, 0 deletions

diff --git a/runtime/queries/sql/folds.scm b/runtime/queries/sql/folds.scm
new file mode 100644
index 000000000..07f2282d0
--- /dev/null
+++ b/runtime/queries/sql/folds.scm
@@ -0,0 +1 @@
+(statement) @fold
diff --git a/runtime/queries/sql/highlights.scm b/runtime/queries/sql/highlights.scm
new file mode 100644
index 000000000..67eef18ae
--- /dev/null
+++ b/runtime/queries/sql/highlights.scm
@@ -0,0 +1,427 @@
+(invocation
+  (object_reference
+    name: (identifier) @function.call))
+
+[
+  (keyword_gist)
+  (keyword_btree)
+  (keyword_hash)
+  (keyword_spgist)
+  (keyword_gin)
+  (keyword_brin)
+  (keyword_array)
+] @function.call
+
+(object_reference
+  name: (identifier) @type)
+
+(relation
+  alias: (identifier) @variable)
+
+(field
+  name: (identifier) @variable.member)
+
+(column_definition
+  name: (identifier) @variable.member)
+
+(term
+  alias: (identifier) @variable)
+
+(term
+  value: (cast
+    name: (keyword_cast) @function.call
+    parameter: (literal)?))
+
+(literal) @string
+
+(comment) @comment @spell
+
+(marginalia) @comment
+
+((literal) @number
+  (#lua-match? @number "^%d+$"))
+
+((literal) @number.float
+  (#lua-match? @number.float "^[-]?%d*\.%d*$"))
+
+(parameter) @variable.parameter
+
+[
+  (keyword_true)
+  (keyword_false)
+] @boolean
+
+[
+  (keyword_asc)
+  (keyword_desc)
+  (keyword_terminated)
+  (keyword_escaped)
+  (keyword_unsigned)
+  (keyword_nulls)
+  (keyword_last)
+  (keyword_delimited)
+  (keyword_replication)
+  (keyword_auto_increment)
+  (keyword_default)
+  (keyword_collate)
+  (keyword_concurrently)
+  (keyword_engine)
+  (keyword_always)
+  (keyword_generated)
+  (keyword_preceding)
+  (keyword_following)
+  (keyword_first)
+  (keyword_current_timestamp)
+  (keyword_immutable)
+  (keyword_atomic)
+  (keyword_parallel)
+  (keyword_leakproof)
+  (keyword_safe)
+  (keyword_cost)
+  (keyword_strict)
+] @attribute
+
+[
+  (keyword_materialized)
+  (keyword_recursive)
+  (keyword_temp)
+  (keyword_temporary)
+  (keyword_unlogged)
+  (keyword_external)
+  (keyword_parquet)
+  (keyword_csv)
+  (keyword_rcfile)
+  (keyword_textfile)
+  (keyword_orc)
+  (keyword_avro)
+  (keyword_jsonfile)
+  (keyword_sequencefile)
+  (keyword_volatile)
+] @keyword.modifier
+
+[
+  (keyword_case)
+  (keyword_when)
+  (keyword_then)
+  (keyword_else)
+] @keyword.conditional
+
+[
+  (keyword_select)
+  (keyword_from)
+  (keyword_where)
+  (keyword_index)
+  (keyword_join)
+  (keyword_primary)
+  (keyword_delete)
+  (keyword_create)
+  (keyword_insert)
+  (keyword_merge)
+  (keyword_distinct)
+  (keyword_replace)
+  (keyword_update)
+  (keyword_into)
+  (keyword_overwrite)
+  (keyword_matched)
+  (keyword_values)
+  (keyword_value)
+  (keyword_attribute)
+  (keyword_set)
+  (keyword_left)
+  (keyword_right)
+  (keyword_outer)
+  (keyword_inner)
+  (keyword_full)
+  (keyword_order)
+  (keyword_partition)
+  (keyword_group)
+  (keyword_with)
+  (keyword_without)
+  (keyword_as)
+  (keyword_having)
+  (keyword_limit)
+  (keyword_offset)
+  (keyword_table)
+  (keyword_tables)
+  (keyword_key)
+  (keyword_references)
+  (keyword_foreign)
+  (keyword_constraint)
+  (keyword_force)
+  (keyword_use)
+  (keyword_for)
+  (keyword_if)
+  (keyword_exists)
+  (keyword_column)
+  (keyword_columns)
+  (keyword_cross)
+  (keyword_lateral)
+  (keyword_natural)
+  (keyword_alter)
+  (keyword_drop)
+  (keyword_add)
+  (keyword_view)
+  (keyword_end)
+  (keyword_is)
+  (keyword_using)
+  (keyword_between)
+  (keyword_window)
+  (keyword_no)
+  (keyword_data)
+  (keyword_type)
+  (keyword_rename)
+  (keyword_to)
+  (keyword_schema)
+  (keyword_owner)
+  (keyword_authorization)
+  (keyword_all)
+  (keyword_any)
+  (keyword_some)
+  (keyword_returning)
+  (keyword_begin)
+  (keyword_commit)
+  (keyword_rollback)
+  (keyword_transaction)
+  (keyword_only)
+  (keyword_like)
+  (keyword_similar)
+  (keyword_over)
+  (keyword_change)
+  (keyword_modify)
+  (keyword_after)
+  (keyword_before)
+  (keyword_range)
+  (keyword_rows)
+  (keyword_groups)
+  (keyword_exclude)
+  (keyword_current)
+  (keyword_ties)
+  (keyword_others)
+  (keyword_zerofill)
+  (keyword_format)
+  (keyword_fields)
+  (keyword_row)
+  (keyword_sort)
+  (keyword_compute)
+  (keyword_comment)
+  (keyword_location)
+  (keyword_cached)
+  (keyword_uncached)
+  (keyword_lines)
+  (keyword_stored)
+  (keyword_virtual)
+  (keyword_partitioned)
+  (keyword_analyze)
+  (keyword_explain)
+  (keyword_verbose)
+  (keyword_truncate)
+  (keyword_rewrite)
+  (keyword_optimize)
+  (keyword_vacuum)
+  (keyword_cache)
+  (keyword_language)
+  (keyword_called)
+  (keyword_conflict)
+  (keyword_declare)
+  (keyword_filter)
+  (keyword_function)
+  (keyword_input)
+  (keyword_name)
+  (keyword_oid)
+  (keyword_oids)
+  (keyword_precision)
+  (keyword_regclass)
+  (keyword_regnamespace)
+  (keyword_regproc)
+  (keyword_regtype)
+  (keyword_restricted)
+  (keyword_return)
+  (keyword_returns)
+  (keyword_separator)
+  (keyword_setof)
+  (keyword_stable)
+  (keyword_support)
+  (keyword_tblproperties)
+  (keyword_trigger)
+  (keyword_unsafe)
+  (keyword_admin)
+  (keyword_connection)
+  (keyword_cycle)
+  (keyword_database)
+  (keyword_encrypted)
+  (keyword_increment)
+  (keyword_logged)
+  (keyword_none)
+  (keyword_owned)
+  (keyword_password)
+  (keyword_reset)
+  (keyword_role)
+  (keyword_sequence)
+  (keyword_start)
+  (keyword_restart)
+  (keyword_tablespace)
+  (keyword_until)
+  (keyword_user)
+  (keyword_valid)
+  (keyword_action)
+  (keyword_definer)
+  (keyword_invoker)
+  (keyword_security)
+  (keyword_extension)
+  (keyword_version)
+  (keyword_out)
+  (keyword_inout)
+  (keyword_variadic)
+  (keyword_session)
+  (keyword_isolation)
+  (keyword_level)
+  (keyword_serializable)
+  (keyword_repeatable)
+  (keyword_read)
+  (keyword_write)
+  (keyword_committed)
+  (keyword_uncommitted)
+  (keyword_deferrable)
+  (keyword_names)
+  (keyword_zone)
+  (keyword_immediate)
+  (keyword_deferred)
+  (keyword_constraints)
+  (keyword_snapshot)
+  (keyword_characteristics)
+  (keyword_off)
+  (keyword_follows)
+  (keyword_precedes)
+  (keyword_each)
+  (keyword_instead)
+  (keyword_of)
+  (keyword_initially)
+  (keyword_old)
+  (keyword_new)
+  (keyword_referencing)
+  (keyword_statement)
+  (keyword_execute)
+  (keyword_procedure)
+] @keyword
+
+[
+  (keyword_restrict)
+  (keyword_unbounded)
+  (keyword_unique)
+  (keyword_cascade)
+  (keyword_delayed)
+  (keyword_high_priority)
+  (keyword_low_priority)
+  (keyword_ignore)
+  (keyword_nothing)
+  (keyword_check)
+  (keyword_option)
+  (keyword_local)
+  (keyword_cascaded)
+  (keyword_wait)
+  (keyword_nowait)
+  (keyword_metadata)
+  (keyword_incremental)
+  (keyword_bin_pack)
+  (keyword_noscan)
+  (keyword_stats)
+  (keyword_statistics)
+  (keyword_maxvalue)
+  (keyword_minvalue)
+] @keyword.modifier
+
+[
+  (keyword_int)
+  (keyword_null)
+  (keyword_boolean)
+  (keyword_binary)
+  (keyword_varbinary)
+  (keyword_image)
+  (keyword_bit)
+  (keyword_inet)
+  (keyword_character)
+  (keyword_smallserial)
+  (keyword_serial)
+  (keyword_bigserial)
+  (keyword_smallint)
+  (keyword_mediumint)
+  (keyword_bigint)
+  (keyword_tinyint)
+  (keyword_decimal)
+  (keyword_float)
+  (keyword_double)
+  (keyword_numeric)
+  (keyword_real)
+  (double)
+  (keyword_money)
+  (keyword_smallmoney)
+  (keyword_char)
+  (keyword_nchar)
+  (keyword_varchar)
+  (keyword_nvarchar)
+  (keyword_varying)
+  (keyword_text)
+  (keyword_string)
+  (keyword_uuid)
+  (keyword_json)
+  (keyword_jsonb)
+  (keyword_xml)
+  (keyword_bytea)
+  (keyword_enum)
+  (keyword_date)
+  (keyword_datetime)
+  (keyword_time)
+  (keyword_datetime2)
+  (keyword_datetimeoffset)
+  (keyword_smalldatetime)
+  (keyword_timestamp)
+  (keyword_timestamptz)
+  (keyword_geometry)
+  (keyword_geography)
+  (keyword_box2d)
+  (keyword_box3d)
+  (keyword_interval)
+] @type.builtin
+
+[
+  (keyword_in)
+  (keyword_and)
+  (keyword_or)
+  (keyword_not)
+  (keyword_by)
+  (keyword_on)
+  (keyword_do)
+  (keyword_union)
+  (keyword_except)
+  (keyword_intersect)
+] @keyword.operator
+
+[
+  "+"
+  "-"
+  "*"
+  "/"
+  "%"
+  "^"
+  ":="
+  "="
+  "<"
+  "<="
+  "!="
+  ">="
+  ">"
+  "<>"
+  (op_other)
+  (op_unary_other)
+] @operator
+
+[
+  "("
+  ")"
+] @punctuation.bracket
+
+[
+  ";"
+  ","
+  "."
+] @punctuation.delimiter
diff --git a/runtime/queries/sql/indents.scm b/runtime/queries/sql/indents.scm
new file mode 100644
index 000000000..34ae079dd
--- /dev/null
+++ b/runtime/queries/sql/indents.scm
@@ -0,0 +1,29 @@
+[
+  (select)
+  (cte)
+  (column_definitions)
+  (case)
+  (subquery)
+  (insert)
+  (when_clause)
+] @indent.begin
+
+(block
+  (keyword_begin)) @indent.begin
+
+(column_definitions
+  ")" @indent.branch)
+
+(subquery
+  ")" @indent.branch)
+
+(cte
+  ")" @indent.branch)
+
+[
+  (keyword_end)
+  (keyword_values)
+  (keyword_into)
+] @indent.branch
+
+(keyword_end) @indent.end
diff --git a/runtime/queries/sql/injections.scm b/runtime/queries/sql/injections.scm
new file mode 100644
index 000000000..602997440
--- /dev/null
+++ b/runtime/queries/sql/injections.scm
@@ -0,0 +1,5 @@
+((comment) @injection.content
+  (#set! injection.language "comment"))
+
+((marginalia) @injection.content
+  (#set! injection.language "comment"))