sqlfmt icon indicating copy to clipboard operation
sqlfmt copied to clipboard

Published 20 hours ago • verified publisher icon mjibson

Purpose: SQL or CockroachDB-flavored SQL?

Open pauldraper opened this issue 5 years ago • 1 comments

This library uses the CockroachDB SQL parser, which effectively limits it to use with just CockroachDB, since CockroachDB lacks significant amounts of SQL support: WITH RECURSIVE, CREATE FUNCTION, and CREATE TYPE. And that's just standard ANSI SQL.

IMO, this should either

  1. advertise as CockroachDB SQL formatter

  2. fork from the CockroachDB parser so as to allow contributions to support SQL syntax (regardless of CockroachDB support).

pauldraper avatar Mar 14 '20 21:03 pauldraper

I agree, we should do 1 and put a notice somewhere on the website. I'll keep this open until that gets done.

madelynnblue avatar Mar 14 '20 22:03 madelynnblue