Skip to content

issues Search Results · repo:coresql/sql-query-identifier language:TypeScript

Filter by

33 results
 (72 ms)

33 results

incoresql/sql-query-identifier (press backspace or delete to remove)

coresql/sql-query-identifier
`SELECT INTO` statement `executionType` is `LISTING`

The following call: const result = identify( SELECT * INTO public.\ MyTable1\ FROM public.\ MyTable2\ ); Yields the following result: [ { start : 0, end : 53, text : SELECT * INTO ...
  • lee-campbell
  • Opened 
    on Dec 17, 2024
  • #81

coresql/sql-query-identifier
CREATE VIRTUAL TABLE in SqLite not identifying as a `CREATE_TABLE`

example sql: CREATE VIRTUAL TABLE email USING fts5(sender, title, body); insert into email (sender, title, body) values ( me , hi , wassup ); select * from email; From: https://github.com/beekeeper-studio/beekeeper-studio/issues/1597 ...
  • rathboma
  • Opened 
    on Jun 9, 2023
  • #71

coresql/sql-query-identifier
Run lint in separate workflow from testing

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 ...
  • MasterOdin
  • Opened 
    on Mar 1, 2023
  • #70

coresql/sql-query-identifier
MySQL `SHOW` commands return executionType UNKNOWN

They should return INFORMATION. For example - SHOW KEYS, SHOW INDEX, SHOW TABLE STATUS
bug
  • rathboma
  • 2
  • Opened 
    on Jan 6, 2023
  • #67

coresql/sql-query-identifier
MySQL 'DELIMITER' keyword is not supported

Currently it seems that this package doesn t support using MySQL s DELIMITER keyword which is commonly used with stored procedures which contain multiple statements. I ve created a very basic example ...
  • mike183
  • Opened 
    on Nov 16, 2022
  • #66

coresql/sql-query-identifier
MySQL '#' syntax for inline comments isn't supported

Currently it seems that this package doesn t support using the # syntax for inline comments in MySQL. Example Input select 1; # inline comment select 2 Expected Output [ { start: 1, end: ...
  • mike183
  • Opened 
    on Nov 16, 2022
  • #65

coresql/sql-query-identifier
END on its own not parsed correctly

Identifying just: END; returns a statement with just ;, which is not correct.
bug
  • MasterOdin
  • Opened 
    on Aug 26, 2022
  • #62

coresql/sql-query-identifier
Support live/window views for clickhouse

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) ...
  • MasterOdin
  • Opened 
    on Aug 24, 2022
  • #59

coresql/sql-query-identifier
FEAT: Support a variety of parameter types per syntax type

For example, Postgresql supports: - $1 - :paramname SQLite: https://www.sqlite.org/c3ref/bind_blob.html - ? - ?NNN - :VVV - @VVV - $VVV MySQL: - ?? - identifiers - ? - values https://github.com/mysqljs/mysql#preparing-queries ...
  • rathboma
  • Opened 
    on Jul 22, 2022
  • #55

coresql/sql-query-identifier
Queries with params immediately followed by a `,` show the comma as part of the parameter name (PSQL)

See https://github.com/beekeeper-studio/beekeeper-studio/issues/1244
  • rathboma
  • 1
  • Opened 
    on Jul 22, 2022
  • #54
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue search results · GitHub