René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Call function in FROM clause (SQLite - json_each or MySQL - json_table)","articleBody":"It seems unsupported to call functions from within the FROM clause. Working example for SQLite:\r\n\r\n```sql\r\nSELECT one.name, group_concat(j.value, ', ') FROM one, json_each(one.stringArray) AS j GROUP BY one.id\r\n```\r\n\r\nTable `one`:\r\n```sql\r\nCREATE TABLE one (\r\n    id INTEGER PRIMARY KEY AUTOINCREMENT,\r\n    name TEXT,\r\n    stringArray TEXT CHECK(json_valid(stringArray))\r\n)\r\n```\r\n\r\nData:\r\n```sql\r\nINSERT INTO \"one\" (\"id\", \"name\", \"stringArray\") VALUES ('1', 'John Doe',    '[\"apple\",\"banana\",\"cherry\"]');\r\nINSERT INTO \"one\" (\"id\", \"name\", \"stringArray\") VALUES ('2', 'Alice Smith', '[\"banana\",\"grape\",\"cherry\"]');\r\nINSERT INTO \"one\" (\"id\", \"name\", \"stringArray\") VALUES ('3', 'Bob Johnson', '[\"banana\",\"apple\",\"grape\"]');\r\n```\r\n\r\n**Update 1**: also does not work with the `json_table` function supported by MySQL (see https://dev.mysql.com/blog-archive/json_table-the-best-of-both-worlds/):\r\n\r\n```sql\r\nSELECT people.* \r\nFROM t1, \r\n     JSON_TABLE(json_col, '$.people[*]' COLUMNS (\r\n                name VARCHAR(40)  PATH '$.name',\r\n                address VARCHAR(100) PATH '$.address')\r\n     ) people;\r\n```","author":{"url":"https://github.com/JYone3A","@type":"Person","name":"JYone3A"},"datePublished":"2024-02-26T10:20:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/60/js-sql-parser/issues/60"}