Matthew Peveler

Looking at https://github.com/coresql/sql-query-identifier/actions/runs/4308916845, many of the reported errors are the same across workflows, and it's just ending up visual noise. Should just run it in its own workflow, especially given...

See https://clickhouse.com/docs/en/sql-reference/statements/create/view, it supports the following two modifiers for creating views: `LIVE` and `WINDOW`: an example usage: ``` CREATE LIVE VIEW lv AS SELECT sum(x) FROM mt; CREATE WINDOW VIEW...

Test query: ```sql CREATE OR REPLACE FUNCTION f_grp_prod(text) RETURNS TABLE ( name text , result1 double precision , result2 double precision) LANGUAGE plpgsql STABLE AS $$ DECLARE r mytable%ROWTYPE; _round...

support identifying explain queries

1

For example, `EXPLAIN SELECT 1`, where this is currently identified as `UNKNOWN`. We should probably support this as it's somewhat common, and easy to support (just detect if first word...

Right now we export the `Dialect` and `ExecutionType` as string union types. While this works, it would be better to use [string enums](https://www.typescriptlang.org/docs/handbook/enums.html#string-enums) like: ``` enum ExecutionType { LISTING =...

Set default for strict to false

1

In both sqlectron and beekeeper-studio, it looks like we pretty universally use sql-query-identifier with `strict: false`. I propose just making that the default as it's probably the better behavior than...

The docs for the query builder: https://github.com/cakephp/phinx/blob/615485032e67d9500cbfa2e53acdb0449e26f191/docs/en/migrations.rst?plain=1#L1646-L1676 These are out of date and need to be updated to make reference to the specific builder methods (e.g. `getSelectBuilder`) that people are...

For sqlite, doing a migration/seed gives an output similar to following: ``` using adapter sqlite using database ./data ``` where the we only print out the database name, but omit...

Multipart uploads sometimes returns URL encoded location

2

### Checkboxes for prior research - [X] I've gone through [Developer Guide](https://docs.aws.amazon.com/sdk-for-javascript/v3/developer-guide) and [API reference](https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest) - [X] I've checked [AWS Forums](https://forums.aws.amazon.com) and [StackOverflow](https://stackoverflow.com/questions/tagged/aws-sdk-js). - [X] I've searched for [previous similar...

Migrating https://github.com/overleaf/web/issues/722 to here. This is still an annoyance to me on the Overleaf platform and continues to be a thing that forces me out of overleaf. For organization of...