commits

SQL queries formatting, syntactic and semantic validation

SHA	Message	Author	Date
9e5bb468	Bump to version 0.0.20.	David Wobrock <d**k@b**m>	over 3 years ago
016dcb27	Update Python and library versions.	David Wobrock <d**k@bm> Committed by: David Wobrock <dk@g**m>	over 3 years ago
33a03460	Added support to tab as token separator. Tab '\t' is a valid token separator ...	Ronaldo Moura <r**a@gm> Committed by: David Wobrock <dk@g**m>	about 4 years ago
7386fce8	Update README.md	Joachim Jablon <e**m@gm> Committed by: David Wobrock <dk@g**m>	over 4 years ago
8bf7ccc6	Add .pre-commit-hooks.yaml for use with pre-commit	Joachim Jablon <e**m@gm> Committed by: David Wobrock <dk@g**m>	over 4 years ago
b88cee96	Bump to 0.0.19	David Wobrock <d**k@g**m>	over 4 years ago
5bba4816	merge Merge pull request #43 from David-Wobrock/handle-nested-case-expressions	David Wobrock <d**k@gm> Committed by: GitHub <ny@g**m>	over 4 years ago
58143547	Fix #38 -- Handle nested case expressions	David Wobrock <d**k@g**m>	over 4 years ago
2827c2a1	merge Merge pull request #42 from David-Wobrock/test-against-python310	David Wobrock <d**k@gm> Committed by: GitHub <ny@g**m>	over 4 years ago
3135c07c	Add Python 3.10 to CI and use 3.9 for linting tasks	David Wobrock <d**k@g**m>	over 4 years ago
eef2747a	merge Merge pull request #40 from David-Wobrock/handle-select-star-replace	David Wobrock <d**k@gm> Committed by: GitHub <ny@g**m>	over 4 years ago
f0b72774	merge Merge pull request #41 from David-Wobrock/upgrade-linting-libs	David Wobrock <d**k@gm> Committed by: GitHub <ny@g**m>	over 4 years ago
71f27c7f	Bump black==22.3.0 and mypy==0.942	David Wobrock <d**k@g**m>	over 4 years ago
a6adc7bf	Implement some column validation for SELECT * REPLACE (...) fields	David Wobrock <d**k@g**m>	over 4 years ago
7a4c0e9e	Refactor duplicated Except & Replace logic for Select * statements	David Wobrock <d**k@g**m>	over 4 years ago
e5019982	Implement SELECT * REPLACE formatting	David Wobrock <d**k@g**m>	over 4 years ago
9705a9b4	Bump to 0.0.18	David Wobrock <d**k@g**m>	over 4 years ago
57745978	Fix #29 -- Handle strings containing others quotes	David Wobrock <d**k@g**m>	over 4 years ago
870a71a7	Upgrade linting libs to latest versions	David Wobrock <d**k@g**m>	over 4 years ago
aa961bcb	Handle chained index based accesses	David Wobrock <d**k@g**m>	over 4 years ago
8fcc1dfc	Fix #35 -- Handle index based access on function call	David Wobrock <d**k@g**m>	over 4 years ago
d7e8b6c4	Fix #34 -- Handle parsing a function with a single comma string	David Wobrock <d**k@g**m>	over 4 years ago
c8c95c0d	Fix mypy type hints, by using object instead of Any	David Wobrock <d**k@g**m>	almost 5 years ago
a3bf4fcc	Fix validating between predicate conditions	David Wobrock <d**k@g**m>	almost 5 years ago
362ec80a	Raise validation error when ambiguous fields between aliased queries	David Wobrock <d**k@g**m>	almost 5 years ago
224c51cd	Detect fields in outer query even when not using the subquery alias	David Wobrock <d**k@g**m>	almost 5 years ago
0eb28476	Handle wrongly parsed chained_columns with arithmetic operator	David Wobrock <d**k@g**m>	almost 5 years ago
3783c6eb	Resolve field types from exposed 'known_fields' during validation	David Wobrock <d**k@g**m>	almost 5 years ago
493269c0	Transform validation 'known_fields' into dataclass	David Wobrock <d**k@g**m>	almost 5 years ago
ee87a119	Drop Python 3.6	David Wobrock <d**k@g**m>	almost 5 years ago
3e7b2f87	Fix handling Any return type as invalid WHERE/HAVING condition	David Wobrock <d**k@g**m>	almost 5 years ago
00eab492	Fix Alias.known_fields for aliased subqueries with specific fields	David Wobrock <d**k@g**m>	almost 5 years ago
67334fc9	Add Alias.known_fields for aliased subqueries	David Wobrock <d**k@g**m>	almost 5 years ago
f89e5590	Allow nested/struct field, which is not an alias necessarily	David Wobrock <d**k@g**m>	almost 5 years ago
17b37010	Update linting deps	David Wobrock <d**k@g**m>	almost 5 years ago
acb966b7	Don't fail on Windows Function with Order By clause	David Wobrock <d**k@g**m>	almost 5 years ago
38b24cb4	Don't accidentally validate an SQL query when only formatting was requested	David Wobrock <d**k@g**m>	almost 5 years ago
91e4ccfd	Check from_statement has known_fields to call it	David Wobrock <d**k@g**m>	almost 5 years ago
197811fc	Implement validation for chained/aliased columns	David Wobrock <d**k@g**m>	almost 5 years ago
14727e2d	Handle validation for FunctionCall & exposed fields by nested subqueries	David Wobrock <d**k@g**m>	almost 5 years ago
39c2984f	Upgrade black & isort	David Wobrock <d**k@g**m>	almost 5 years ago
2d87ce44	Bump to 0.0.17	David Wobrock <d**k@g**m>	about 5 years ago
38581286	Fix #26 -- Add basic WITH-statement handling	David Wobrock <d**k@g**m>	about 5 years ago
9de2c9d0	Fix #24 -- Handle (aggregate) functions with filter	David Wobrock <d**k@g**m>	about 5 years ago
9201d188	Update linting libs	David Wobrock <d**k@g**m>	about 5 years ago
079e317f	Fix #23 -- Handle escaped strings in formatting	David Wobrock <d**k@g**m>	about 5 years ago
fb512610	Update linting libs to latest state	David Wobrock <d**k@g**m>	about 5 years ago
ee6b9d6d	Fix #25 -- Handle JOIN EACH syntax from Legacy BigQuery SQL dialect	David Wobrock <d**k@g**m>	about 5 years ago
fccfe984	Fix #22 -- Handle GROUP EACH BY clause from Legacy BigQuery SQL dialect	David Wobrock <d**k@g**m>	about 5 years ago
6484ebcd	Fix setup.py for correct package installation	David Wobrock <d**k@g**m>	about 5 years ago
2514a802	Update pytest	David Wobrock <d**k@g**m>	about 5 years ago
048ce065	Rename master branch to main	David Wobrock <d**k@g**m>	about 5 years ago
a499ce11	Bump to 0.0.16	David Wobrock <d**k@g**m>	over 5 years ago
39f26ae0	merge Merge pull request #19 from David-Wobrock/improve-sql-validation	David Wobrock <d**k@gm> Committed by: GitHub <ny@g**m>	over 5 years ago
32fa0eac	Allow having an index on a chained column	David Wobrock <d**k@g**m>	over 5 years ago
a83d37ec	Add missing return statement	David-Wobrock <d**k@g**m>	over 5 years ago
83cb5a0a	Fix linting and tests	David-Wobrock <d**k@g**m>	over 5 years ago
b8e2adb2	Fix analysing when neither formatting or analysing	David Wobrock <d**k@g**m>	over 5 years ago
68d65d79	Fix string alias	David Wobrock <d**k@g**m>	over 5 years ago
02ed5945	Fix summary message	David Wobrock <d**k@g**m>	over 5 years ago
b166f409	Allow formatting invalid JOIN, but detect it in validation	David Wobrock <d**k@g**m>	over 5 years ago
faa8e9bb	Add verbose-validation option	David-Wobrock <d**k@g**m>	over 5 years ago
de5c2238	Fix bugs in validation	David-Wobrock <d**k@g**m>	over 5 years ago
ef9b7f84	Display correct file path	David-Wobrock <d**k@g**m>	over 5 years ago
cc5c0a35	Linting	David-Wobrock <d**k@g**m>	over 5 years ago
a092fc86	Validate group by alias against aliases in SELECT	David-Wobrock <d**k@g**m>	over 5 years ago
789c9289	Add --validate option	David-Wobrock <d**k@g**m>	over 5 years ago
65c4b227	Fix some unnest parsing	David-Wobrock <d**k@g**m>	over 5 years ago
7734d5ba	Fix ARRAY_AGG function call with only one arg	David-Wobrock <d**k@g**m>	over 5 years ago
3000a4f6	Add '!=' symbol to known conditions	David-Wobrock <d**k@g**m>	over 5 years ago
f85e58ba	Add Contributing section to README	David-Wobrock <d**k@g**m>	over 5 years ago
f3c23ee7	Fix variable leaking from one condition to another	David-Wobrock <d**k@g**m>	over 5 years ago
f6462b9d	Bump to 0.0.15	David-Wobrock <d**k@g**m>	over 5 years ago
1d70d241	Handle count functions specially (with distinct keyword)	David-Wobrock <d**k@g**m>	over 5 years ago
1221fe3d	Add date to extract parts	David-Wobrock <d**k@g**m>	over 5 years ago
8e444522	Bump to 0.0.14	David-Wobrock <d**k@g**m>	over 5 years ago
a44cca59	Fixes #18 -- Handle quoted table string	David-Wobrock <d**k@g**m>	over 5 years ago
e71e7fa5	Add bitwise operation tokens	David-Wobrock <d**k@g**m>	over 5 years ago
36037095	Handle 'contains' predicate	David-Wobrock <d**k@g**m>	over 5 years ago
5cbb0f52	Handle 'not in' predicate	David-Wobrock <d**k@g**m>	over 5 years ago
1816f931	Handle basic floating point numbers	David-Wobrock <d**k@g**m>	over 5 years ago
46a6a3be	Fix 'date' column in if (a bit approx solution, but works for now)	David-Wobrock <d**k@g**m>	over 5 years ago
e6d2d62d	Fix query after condition 'is null'	David-Wobrock <d**k@g**m>	over 5 years ago
4a1d62ac	Add __eq__ on WhereClause and Condition	David-Wobrock <d**k@g**m>	over 5 years ago
20e44e9c	bump to v0.0.13	David-Wobrock <d**k@g**m>	over 5 years ago
f24a6a4b	Handle empty array	David-Wobrock <d**k@g**m>	over 5 years ago
16936769	Propagate 'until_one_of' parameter in Expression parser	David-Wobrock <d**k@g**m>	over 5 years ago
9c2e0c29	Implement BigQuery's ArrayAgg function call	David-Wobrock <d**k@g**m>	over 5 years ago
c2c3f6aa	Have smarter Where and Having parsing, not just until a certain keyword	David-Wobrock <d**k@g**m>	over 5 years ago
53c73701	Implement chained columns + arrays	David-Wobrock <d**k@g**m>	over 5 years ago
683388a4	Fix wrong positive in SQL parsing	David-Wobrock <d**k@g**m>	over 5 years ago
0a343e0a	Implement union all and fix formatting	David-Wobrock <d**k@g**m>	over 5 years ago
0e0640b1	merge Merge pull request #17 from David-Wobrock/automatic-select-formatting	David Wobrock <d**k@gm> Committed by: GitHub <ny@g**m>	over 5 years ago
4b3ce553	Implement legacy BigQuery table name in square brackets	David-Wobrock <d**k@g**m>	over 5 years ago
7bda71a2	Don't depend on sqlformat comment anymore	David-Wobrock <d**k@g**m>	over 5 years ago
6e58988c	Do not run project and patch codecov status	David-Wobrock <d**k@g**m>	over 5 years ago
e9da331e	Bump to 0.0.12	David-Wobrock <d**k@g**m>	over 5 years ago
bbb13e72	Don't fail CI if coverage fails	David-Wobrock <d**k@g**m>	over 5 years ago
d88d604a	Handle 'IN' predicate for conditions	David-Wobrock <d**k@g**m>	over 5 years ago
b760e070	Fix assert of 'with offset' to use 'lower'	David-Wobrock <d**k@g**m>	over 5 years ago

← Back to repository

ecosyste.ms

Data

Tools

Indexes

Applications

Experiments

Commits

GitHub / David-Wobrock/sqlvalidator / commits