SQL Formatter for Stored Procedures
Your data never leaves your browserFormat to separate SQL from procedural logic.
Example
CREATE OR REPLACE PROCEDURE update_stats(p_user_id INT) LANGUAGE SQL AS $$ UPDATE stats SET count = (SELECT COUNT(*) FROM logs WHERE user_id = p_user_id) WHERE user_id = p_user_id; $$;
Tips
- 1Format SQL inside separately.
- 2Indent parameters.
- 3Separate declarations from queries.
Frequently Asked Questions
Procedural logic?
SQL formats. IF/LOOP: basic.
Triggers?
Yes.
All databases?
Select dialect.