Rene Saarsoo
Rene Saarsoo
That's just a placeholder issue to reference some examples of real SQL in the wild. So I can better prioritize which parts of syntax to support. ### PostgreSQL - https://github.com/giveffektivt/donation-platform/blob/main/db/migrations/99999999999999_views.sql...
- [ ] [DECLARE](https://www.postgresql.org/docs/17/sql-declare.html) - [ ] `DECLARE name CURSOR FOR query` - [ ] `[ BINARY ]` - [ ] `[ ASENSITIVE | INSENSITIVE ]` - [ ] `[...
### [JSON functions](https://www.postgresql.org/docs/17/functions-json.html) - [ ] `JSON_OBJECT(...)` #84 - [ ] `json_object('code' VALUE 'P123')` - [ ] `json_object('title': 'Jaws')` - [ ] `[ FORMAT JSON [ ENCODING UTF8 ] ]`...
### Operator - [ ] [CREATE OPERATOR](https://www.postgresql.org/docs/current/sql-createoperator.html) - [ ] `op_name` (allow valid operator characters) - [ ] `schema.op_name` - [ ] `{FUNCTION | PROCEDURE} = func_name` - [ ]...
For example the following is valid in PostgreSQL, but currently causes a crash: ```sql SELECT set.foo FROM settings AS set ``` ``` Syntax Error: Unexpected "set" --> undefined:1:8 | 1...
### Extensions - [x] [CREATE EXTENSION](https://www.postgresql.org/docs/current/sql-createextension.html) - [x] `IF NOT EXISTS` - [x] `extension_name` - [x] `WITH` - [x] `SCHEMA schema_name` - [x] `VERSION version` - [x] `CASCADE` - [...
We're currently using the [SQLite keywords list]() as the list of reserved keywords for SQLite. But not all of these keywords are actually fully reserved. Some can always be used...
Support the [DELIMITER](https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html) command used by the [mysql client](https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html), as in: ```sql delimiter // CREATE PROCEDURE dorepeat(p1 INT) BEGIN SET @x = 0; REPEAT SET @x = @x + 1;...
Created a playground example with a toggle button that switches between two URL-s: https://brianzinn.github.io/react-babylonjs/playground?snippetId=CTqBHrbd But the image used by the texture is not updating. This possibly happens because setting the...
I was hoping to write the following: ```js function MyComp() { return (); } ``` But no such prop is available. So instead I need to do the following: ```js...