I do have some feedback on this component. I love it, but of course there are some areas where improvement can be made. For instance, in the screenshot below, I have highlighted some words where improvement can be made.
- ‘1,2,3,5’ – Literals in SSMS are Red
- ‘ER – 100% OF MEDICARE’ – OF is highlighted in Blue. It is contained in a literal and shouldn’t be highlighted
- ISNULL – Is a function and should be highlighted in Blue
I am also interested in an improved version of the SqlTagger. Here is the test SQL I used to check the highlighter:
-- single-line comment
--- triple-dash comment
/* block comment start
/* nested block comment */
*/
CREATE TEMP TABLE "Group_Stats"(id SERIAL PRIMARY KEY,group_id INT,"SELECTED" BOOLEAN,data JSONB,note TEXT);
INSERT INTO "Group_Stats"(group_id, "SELECTED", data, note) VALUES
(1, true, '{"a":1,"b":[1,2]}'::jsonb, E'Line1\nQuote: 'single''),
(2, false, $Dollar: contains "double" and 'single'$)
RETURNING id, note;
WITH nums AS (SELECT generate_series(1,3) AS n)
SELECT g.id,g.group_id AS GROUP_ID, -- alias that looks like a keyword
g."SELECTED",
unnest(ARRAY[1,2,3]) AS u,
COUNT(*) OVER (PARTITION BY g.group_id) AS cnt
FROM "Group_Stats" g JOIN LATERAL (SELECT 1) l ON true
WHERE g.note IS NOT NULL GROUP BY g.id, g.group_id, g."SELECTED" ORDER BY cnt DESC
LIMIT 5;
DO $do$
BEGIN
RAISE NOTICE 'DO block with ''embedded'' quotes and $dollar$';
END
$do$;
EXPLAIN SELECT * FROM "Group_Stats" WHERE note LIKE '%Quote%';
COMMENT ON COLUMN "Group_Stats".note IS 'Contains -- dashes and ''quotes''';
SELECT data @> '{"a":1}'::jsonb AS has_a FROM "Group_Stats" LIMIT 1;
SELECT DISTINCT ON (group_id) id, note COLLATE "C" FROM "Group_Stats" ORDER BY group_id, id DESC;
SELECT 1 INTERSECT SELECT 1 EXCEPT SELECT 2;
SELECT ('123'::int + $1::int) AS sum_with_param LIMIT 1;
