Ted Conbeer comments

Results 58 comments of


                                            Ted Conbeer

Respect case-sensitive json key path extractions

Thanks for the report, @sgoley ! BigQuery is case-sensitive when accessing JSON properties using dot notation, also (mentioned in [this discussion](https://github.com/tconbeer/sqlfmt/discussions/229#discussioncomment-3311469)). I don't think I'll be solving the BQ issue,...

CREATE TABLE — define a new table

`create table my_table ( ... )` breaks a lot of "rules" elsewhere in SQL... in particular, the space between the table name and the parens, and the really the use...

CREATE TABLE — define a new table

@pauldes Admittedly this is not my top priority right now. Looking back at this with fresh eyes, it would be relatively easy to auto-format to something like the following: ```sql...

Postgres bitwise xor (`#`) operator formatting

ugh, yeah, I didn't know that symbol had meaning in postgres. We parse it as a comment for MySql compatibility. I think we'll have to create a Postgres dialect that...

Postgres bitwise xor (`#`) operator formatting

It was just brought to my attention that there are two other PG operators that start with `#`; JSON path accessors `#>` and `#>>`. sqlfmt is very broken for them,...

INSERT INTO

See https://github.com/tconbeer/sqlfmt/issues/262 PRs welcome

integer division // operator reformatted as comment

Yeah, this is unfortunate. I checked as many dialects as I could and thought we were in the clear with `//` Will have to be fixed with either a snowflake...

Column formatting breaks with unary operators

Thanks for the report -- this one should be an easy fix.

Column formatting breaks with unary operators

> this one should be an easy fix Famous last words. This requires changes in quite a few places. Right now we support unaries in front of numbers by lexing...

CREATE VIEW

This is expected behavior right now; see #262