{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":347277349,"defaultBranch":"main","name":"sqlglot","ownerLogin":"tobymao","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2021-03-13T05:01:56.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/8205034?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1716160920.0","currentOid":""},"activityList":{"items":[{"before":"d468f92a16decabdf847d7de19f82d65d1939d92","after":"358f30cc02959275c53a2ee9eccde04ddc6a74a5","ref":"refs/heads/main","pushedAt":"2024-05-20T11:18:36.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Chore: remove redundant postgres JSONB token mapping","shortMessageHtmlLink":"Chore: remove redundant postgres JSONB token mapping"}},{"before":"767ed187550f08ad7bd9a4f95c67d58bcad8fdf9","after":"d468f92a16decabdf847d7de19f82d65d1939d92","ref":"refs/heads/main","pushedAt":"2024-05-20T10:52:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Fix(doris): dont generate arrows for JSONExtract* closes #3513","shortMessageHtmlLink":"Fix(doris): dont generate arrows for JSONExtract* closes #3513"}},{"before":"33ab3536d68203f4fceee63507b5c73076d48ed7","after":"767ed187550f08ad7bd9a4f95c67d58bcad8fdf9","ref":"refs/heads/main","pushedAt":"2024-05-20T10:29:20.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"fix doris not support ->> character (#3514)","shortMessageHtmlLink":"fix doris not support ->> character (#3514)"}},{"before":"d958bba8494b8bca9cf3ffef0384690bafd78393","after":"33ab3536d68203f4fceee63507b5c73076d48ed7","ref":"refs/heads/main","pushedAt":"2024-05-20T10:28:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Fix(snowflake): parse certain DB_CREATABLES as identifiers","shortMessageHtmlLink":"Fix(snowflake): parse certain DB_CREATABLES as identifiers"}},{"before":"5cecbfa63a770c4d623f4a5f76d1a7a5f59d087d","after":"d958bba8494b8bca9cf3ffef0384690bafd78393","ref":"refs/heads/main","pushedAt":"2024-05-20T10:20:27.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Feat(snowflake): add support for CREATE WAREHOUSE (#3510)\n\n* Update tokens.py add TokenType.WAREHOUSE.\r\n\r\n* Update test_snowflake.py add one unit test.\r\n\r\n* Update snowflake.py update Tokenizer to recognize TokenType.WAREHOUSE.\r\n\r\n* Update sqlglot/expressions.py\r\n\r\n* Update expressions.py update exp.Warehouse with arg_types.\r\n\r\n* Update parser.py update DB_CREATABLES with TokenType.WAREHOUSE and parse_table_parts() with support for creating exp.Warehouse.\r\n\r\n* Update parser.py adding method _parse_warehouse() stub method with identifier.\r\n\r\n* Update test_snowflake.py removing other test cases in order to get PR finalized.\r\n\r\n* Update snowflake.py update TRANSFORMS to include exp.Warehous.\r\n\r\n* Autoformat.\r\n\r\n* Update snowflake.py expressions.py parser.py remove exp.Warehouse and use exp.Table with kind WAREHOUSE instead.\r\n\r\n* Autoformat.\r\n\r\n* Update parser.py remove _parse_warehouse() as not needed.","shortMessageHtmlLink":"Feat(snowflake): add support for CREATE WAREHOUSE (#3510)"}},{"before":"74311c92091ab28deaaa6a78f9e0d0337e7d957a","after":"5cecbfa63a770c4d623f4a5f76d1a7a5f59d087d","ref":"refs/heads/main","pushedAt":"2024-05-20T06:12:48.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"fix: unnest identifier closes #3512","shortMessageHtmlLink":"fix: unnest identifier closes #3512"}},{"before":"77d21d9379c3f130b803ea651ec3d36256bb84a4","after":"74311c92091ab28deaaa6a78f9e0d0337e7d957a","ref":"refs/heads/main","pushedAt":"2024-05-19T23:25:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"docs: update API docs, CHANGELOG.md for v23.17.0 [skip ci]","shortMessageHtmlLink":"docs: update API docs, CHANGELOG.md for v23.17.0 [skip ci]"}},{"before":"609999110116383ac9a430d5f6a49dd815a15ec8","after":null,"ref":"refs/heads/jo/parse_databricks_colon_as_json_extract","pushedAt":"2024-05-19T06:12:21.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"}},{"before":"11256629d74c4721ed13ed534509d266e260dde6","after":"77d21d9379c3f130b803ea651ec3d36256bb84a4","ref":"refs/heads/main","pushedAt":"2024-05-19T06:12:20.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"Fix(databricks)!: parse : operator as JSONExtract (similar to Snowflake) (#3508)\n\n* Fix(databricks)!: parse : operator as JSONExtract (similar to Snowflake)\r\n\r\n* Flip conjunction operand order","shortMessageHtmlLink":"Fix(databricks)!: parse : operator as JSONExtract (similar to Snowfla…"}},{"before":"145456d050278ea521d8cff973a5d5ecf2aab898","after":null,"ref":"refs/heads/toby/typed_lambdas","pushedAt":"2024-05-19T06:10:09.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"}},{"before":"4ca93c13c8c930e6c4bf74eae83823fc2a727fcb","after":"11256629d74c4721ed13ed534509d266e260dde6","ref":"refs/heads/main","pushedAt":"2024-05-19T06:10:08.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"feat: add support for snowflake lambdas with type annotations closes … (#3506)\n\n* feat: add support for snowflake lambdas with type annotations closes #3505\r\n\r\nSnowflake allows for arguments in lambdas to have a type annotation.\r\nThis is equivalent to casting the values in the lambda.\r\n\r\nhttps://docs.snowflake.com/en/sql-reference/functions/transform#multiply-each-element-in-an-array-by-a-value\r\n\r\n* Update sqlglot/parser.py\r\n\r\nCo-authored-by: Jo <46752250+georgesittas@users.noreply.github.com>\r\n\r\n* feat: add support for snowflake lambdas with type annotations closes #3505\r\n\r\nSnowflake allows for arguments in lambdas to have a type annotation.\r\nThis is equivalent to casting the values in the lambda.\r\n\r\nhttps://docs.snowflake.com/en/sql-reference/functions/transform#multiply-each-element-in-an-array-by-a-value\r\n\r\n* Update sqlglot/parser.py\r\n\r\nCo-authored-by: Jo <46752250+georgesittas@users.noreply.github.com>\r\n\r\n---------\r\n\r\nCo-authored-by: Jo <46752250+georgesittas@users.noreply.github.com>","shortMessageHtmlLink":"feat: add support for snowflake lambdas with type annotations closes … ("}},{"before":"d1ac22a31ee007dd75c1fc9662051c0e2653f0ef","after":"145456d050278ea521d8cff973a5d5ecf2aab898","ref":"refs/heads/toby/typed_lambdas","pushedAt":"2024-05-19T06:09:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"Update sqlglot/parser.py\n\nCo-authored-by: Jo <46752250+georgesittas@users.noreply.github.com>","shortMessageHtmlLink":"Update sqlglot/parser.py"}},{"before":"015de105ba9d28b0823395e6801ba8097ef9dfdf","after":"d1ac22a31ee007dd75c1fc9662051c0e2653f0ef","ref":"refs/heads/toby/typed_lambdas","pushedAt":"2024-05-19T06:08:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"feat: add support for snowflake lambdas with type annotations closes #3505\n\nSnowflake allows for arguments in lambdas to have a type annotation.\nThis is equivalent to casting the values in the lambda.\n\nhttps://docs.snowflake.com/en/sql-reference/functions/transform#multiply-each-element-in-an-array-by-a-value","shortMessageHtmlLink":"feat: add support for snowflake lambdas with type annotations closes #…"}},{"before":"17c7cdb5a0eee700978701e3dd85600cdab26a1f","after":"015de105ba9d28b0823395e6801ba8097ef9dfdf","ref":"refs/heads/toby/typed_lambdas","pushedAt":"2024-05-19T06:06:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"Update sqlglot/parser.py\n\nCo-authored-by: Jo <46752250+georgesittas@users.noreply.github.com>","shortMessageHtmlLink":"Update sqlglot/parser.py"}},{"before":"a7adf6ed5195c6d7c31c24af9e9271e35e579c3f","after":"609999110116383ac9a430d5f6a49dd815a15ec8","ref":"refs/heads/jo/parse_databricks_colon_as_json_extract","pushedAt":"2024-05-18T17:09:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Flip conjunction operand order","shortMessageHtmlLink":"Flip conjunction operand order"}},{"before":null,"after":"a7adf6ed5195c6d7c31c24af9e9271e35e579c3f","ref":"refs/heads/jo/parse_databricks_colon_as_json_extract","pushedAt":"2024-05-18T16:58:42.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Fix(databricks)!: parse : operator as JSONExtract (similar to Snowflake)","shortMessageHtmlLink":"Fix(databricks)!: parse : operator as JSONExtract (similar to Snowflake)"}},{"before":null,"after":"17c7cdb5a0eee700978701e3dd85600cdab26a1f","ref":"refs/heads/toby/typed_lambdas","pushedAt":"2024-05-18T04:46:14.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"feat: add support for snowflake lambdas with type annotations closes #3505\n\nSnowflake allows for arguments in lambdas to have a type annotation.\nThis is equivalent to casting the values in the lambda.\n\nhttps://docs.snowflake.com/en/sql-reference/functions/transform#multiply-each-element-in-an-array-by-a-value","shortMessageHtmlLink":"feat: add support for snowflake lambdas with type annotations closes #…"}},{"before":"c995b1b4a47d0ac902c22270fed2ca4381854e7a","after":"4ca93c13c8c930e6c4bf74eae83823fc2a727fcb","ref":"refs/heads/main","pushedAt":"2024-05-18T01:02:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"docs: update API docs, CHANGELOG.md for v23.16.0 [skip ci]","shortMessageHtmlLink":"docs: update API docs, CHANGELOG.md for v23.16.0 [skip ci]"}},{"before":"da9acf5d57ed0b978c02daf1254d1f67d9533697","after":"c995b1b4a47d0ac902c22270fed2ca4381854e7a","ref":"refs/heads/main","pushedAt":"2024-05-18T00:49:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Simplify","shortMessageHtmlLink":"Simplify"}},{"before":"9aee21b88e73809e2cdc4e48f04e16edcf1141d7","after":"da9acf5d57ed0b978c02daf1254d1f67d9533697","ref":"refs/heads/main","pushedAt":"2024-05-18T00:47:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Cleanup a couple of noisy constants, restore snowflake overriding","shortMessageHtmlLink":"Cleanup a couple of noisy constants, restore snowflake overriding"}},{"before":"e281db8784682649be305e9a05c45211402f107c","after":"9aee21b88e73809e2cdc4e48f04e16edcf1141d7","ref":"refs/heads/main","pushedAt":"2024-05-18T00:46:58.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Feat: add RETURNS NULL ON NULL and STRICT properties (#3504)","shortMessageHtmlLink":"Feat: add RETURNS NULL ON NULL and STRICT properties (#3504)"}},{"before":"05cf6e5b6d7899960503af6628b32f5de7b2419e","after":null,"ref":"refs/heads/jo/returns_null_on_null","pushedAt":"2024-05-18T00:46:58.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"}},{"before":"27362d67275fb794505031be3c28f442313418b7","after":null,"ref":"refs/heads/vaggelisd/alter_set","pushedAt":"2024-05-18T00:37:43.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"}},{"before":"b7ce9c3018661f7b375bfe9d354d01728e0d37cc","after":"e281db8784682649be305e9a05c45211402f107c","ref":"refs/heads/main","pushedAt":"2024-05-18T00:37:42.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"feat!: Add ALTER TABLE SET (#3485)\n\n* feat: Add ALTER TABLE SET\r\n\r\n* PR Feedback 1\r\n\r\n* PR Feedback 2\r\n\r\n* PR Feedback 3\r\n\r\n* Fix test_parser format\r\n\r\n* Refactor comment","shortMessageHtmlLink":"feat!: Add ALTER TABLE SET (#3485)"}},{"before":null,"after":"05cf6e5b6d7899960503af6628b32f5de7b2419e","ref":"refs/heads/jo/returns_null_on_null","pushedAt":"2024-05-18T00:29:54.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"georgesittas","name":"Jo","path":"/georgesittas","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/46752250?s=80&v=4"},"commit":{"message":"Feat: add RETURNS NULL ON NULL and STRICT properties","shortMessageHtmlLink":"Feat: add RETURNS NULL ON NULL and STRICT properties"}},{"before":"0896d113b94aaea82e90dd04cdf917dfa546d08e","after":"b7ce9c3018661f7b375bfe9d354d01728e0d37cc","ref":"refs/heads/main","pushedAt":"2024-05-17T23:56:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"github-actions[bot]","name":null,"path":"/apps/github-actions","primaryAvatarUrl":"https://avatars.githubusercontent.com/in/15368?s=80&v=4"},"commit":{"message":"docs: update API docs, CHANGELOG.md for v23.15.10 [skip ci]","shortMessageHtmlLink":"docs: update API docs, CHANGELOG.md for v23.15.10 [skip ci]"}},{"before":"e8600e24370a131a0b375a1a9943fdf590968198","after":"0896d113b94aaea82e90dd04cdf917dfa546d08e","ref":"refs/heads/main","pushedAt":"2024-05-17T23:55:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"chore: lint","shortMessageHtmlLink":"chore: lint"}},{"before":"6e7f37af86a4f36ec47ea4ef3519e5c97376e090","after":"e8600e24370a131a0b375a1a9943fdf590968198","ref":"refs/heads/main","pushedAt":"2024-05-17T23:51:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"tobymao","name":"Toby Mao","path":"/tobymao","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/8205034?s=80&v=4"},"commit":{"message":"fix: property eq needs highest precedence","shortMessageHtmlLink":"fix: property eq needs highest precedence"}},{"before":"2b8095de1f213917234133ceb7d6c744da78cd19","after":"27362d67275fb794505031be3c28f442313418b7","ref":"refs/heads/vaggelisd/alter_set","pushedAt":"2024-05-17T18:03:27.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"VaggelisD","name":"Vaggelis Danias","path":"/VaggelisD","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16211491?s=80&v=4"},"commit":{"message":"Refactor comment","shortMessageHtmlLink":"Refactor comment"}},{"before":"4f8c8613e91bf7abe7dcbd107e1dbc264d3bed1b","after":"2b8095de1f213917234133ceb7d6c744da78cd19","ref":"refs/heads/vaggelisd/alter_set","pushedAt":"2024-05-17T17:52:45.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"VaggelisD","name":"Vaggelis Danias","path":"/VaggelisD","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/16211491?s=80&v=4"},"commit":{"message":"Fix test_parser format","shortMessageHtmlLink":"Fix test_parser format"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAETrYthgA","startCursor":null,"endCursor":null}},"title":"Activity · tobymao/sqlglot"}