{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":9105770,"defaultBranch":"main","name":"soql-reference","ownerLogin":"socrata-platform","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2013-03-29T20:13:28.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/12076358?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1717097465.0","currentOid":""},"activityList":{"items":[{"before":"42e7a650d294784bbb2c19f70fdde41d00f5c69b","after":"53f413d67f63ab20d6d66b90ad0fbb580b7b5f28","ref":"refs/heads/main","pushedAt":"2024-05-30T19:31:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"v4.14.55","shortMessageHtmlLink":"v4.14.55"}},{"before":"c551faa6baf4c3a08471da2a5349b48f59c6ab6f","after":null,"ref":"refs/heads/rjm/foundtables-by-table-name","pushedAt":"2024-05-30T19:30:09.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"}},{"before":"489afcf0cf2596a2d9c3894ede366e840b4453d6","after":"42e7a650d294784bbb2c19f70fdde41d00f5c69b","ref":"refs/heads/main","pushedAt":"2024-05-30T19:30:06.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Merge pull request #397 from socrata-platform/rjm/foundtables-by-table-name\n\nHelper for looking up found tables by their database table name","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2326389399\" data-permission-text=\"Title is private\" data-url=\"https://github.com/socrata-platform/soql-reference/issues/397\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/socrata-platform/soql-reference/pull/397/hovercard\" href=\"https://github.com/socrata-platform/soql-reference/pull/397\">#397</a> from socrata-platform/rjm/foundtables-by-tabl…"}},{"before":null,"after":"c551faa6baf4c3a08471da2a5349b48f59c6ab6f","ref":"refs/heads/rjm/foundtables-by-table-name","pushedAt":"2024-05-30T19:18:36.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Helper for looking up found tables by their database table name\n\nIt's possible (albeit uncommon) for a table to have more than one\nreferencing ScopedResourceName so this produces a map from DTN\nto a non-empty seq of scoped resource names.","shortMessageHtmlLink":"Helper for looking up found tables by their database table name"}},{"before":"fd0f566a8f35de476ab414ec9ae8bab4e7c4a4a0","after":null,"ref":"refs/heads/rjm/table-ops-and-hidden-columns","pushedAt":"2024-05-29T20:08:21.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"}},{"before":"86dde8d6ed5e17bef82ab525b99d959a70f9d5e2","after":"489afcf0cf2596a2d9c3894ede366e840b4453d6","ref":"refs/heads/main","pushedAt":"2024-05-29T20:08:17.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Merge pull request #396 from socrata-platform/rjm/table-ops-and-hidden-columns\n\nMake hidden columns work with top-level table-op nodes","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2324029181\" data-permission-text=\"Title is private\" data-url=\"https://github.com/socrata-platform/soql-reference/issues/396\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/socrata-platform/soql-reference/pull/396/hovercard\" href=\"https://github.com/socrata-platform/soql-reference/pull/396\">#396</a> from socrata-platform/rjm/table-ops-and-hidde…"}},{"before":null,"after":"fd0f566a8f35de476ab414ec9ae8bab4e7c4a4a0","ref":"refs/heads/rjm/table-ops-and-hidden-columns","pushedAt":"2024-05-29T18:54:22.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Make hidden columns work with top-level table-op nodes","shortMessageHtmlLink":"Make hidden columns work with top-level table-op nodes"}},{"before":null,"after":"70f096671d32b4ecba71de0b8c339745360d1e67","ref":"refs/heads/rjm/extract-alias-analysis-context-finder","pushedAt":"2024-05-29T17:34:37.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Extract building the alias analysis context into a public static function\n\nBecause it's sometimes useful when doing a partial analysis","shortMessageHtmlLink":"Extract building the alias analysis context into a public static func…"}},{"before":"8ddcc411206c4a7bf8a199925631672c10c4d48c","after":"86dde8d6ed5e17bef82ab525b99d959a70f9d5e2","ref":"refs/heads/main","pushedAt":"2024-05-21T23:39:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"v4.14.54","shortMessageHtmlLink":"v4.14.54"}},{"before":"f1579ab434e79d27601cfda210c68948abfc0049","after":"8ddcc411206c4a7bf8a199925631672c10c4d48c","ref":"refs/heads/main","pushedAt":"2024-05-21T23:38:40.000Z","pushType":"pr_merge","commitsCount":5,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Merge pull request #394 from socrata-platform/rjm/moar-functions\n\nMore functions!","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2308715004\" data-permission-text=\"Title is private\" data-url=\"https://github.com/socrata-platform/soql-reference/issues/394\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/socrata-platform/soql-reference/pull/394/hovercard\" href=\"https://github.com/socrata-platform/soql-reference/pull/394\">#394</a> from socrata-platform/rjm/moar-functions"}},{"before":"eb39b0729e26e1a0833debeb36dbc0cc27b24330","after":"9066bd2976b5e90631f00da94321b5d78a432b72","ref":"refs/heads/rjm/moar-functions","pushedAt":"2024-05-21T22:29:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Use ad-hoc rewrites when checking group bys\n\nAnd add some date-related ad-hoc rewrites","shortMessageHtmlLink":"Use ad-hoc rewrites when checking group bys"}},{"before":"234825799d6becff6ea3724e3aa0429eb3174cef","after":"eb39b0729e26e1a0833debeb36dbc0cc27b24330","ref":"refs/heads/rjm/moar-functions","pushedAt":"2024-05-21T21:51:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Testing stuff around rollups and the new functions","shortMessageHtmlLink":"Testing stuff around rollups and the new functions"}},{"before":"dd24658b39b3e25e7d935af078c158805ec52969","after":"234825799d6becff6ea3724e3aa0429eb3174cef","ref":"refs/heads/rjm/moar-functions","pushedAt":"2024-05-16T20:30:29.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Change the name of the \"date\" type to \"datestamp\"\n\nThis is unfortunate, but it does prevent an unfortunate overlap with\ncore types, which use \"date\" for what we call \"fixed_timestamp\"","shortMessageHtmlLink":"Change the name of the \"date\" type to \"datestamp\""}},{"before":null,"after":"dd24658b39b3e25e7d935af078c158805ec52969","ref":"refs/heads/rjm/moar-functions","pushedAt":"2024-05-15T22:52:06.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"More functions!\n\n* Field-syntax access for parts of floating_timestamps, dates, and times\n** including fieldlike access to \"date\" and \"time\" parts of timestamps\n* Add a time to a date to get a floating_timestamp\n* Add or subtract an interval to a time to get a new time\n* Subtract two times to get an interval\n* Add an interval to a date to get a floating_timestamp (not sure why\n  the discrepancy, but it's what PG does)\n* Subtract an interval from a date to get a floating_timestamp\n* Find the difference between two dates in days\n* Truncate a date at year or month\n* Convert timestamps, dates, times, intervals to ISO8601 via cast-to-text\n* Convert row identifiers and row versions to text via cast","shortMessageHtmlLink":"More functions!"}},{"before":"63a9814130be0b0b0e7feea828c0d6ff573596a1","after":"f1579ab434e79d27601cfda210c68948abfc0049","ref":"refs/heads/main","pushedAt":"2024-05-13T20:23:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"v4.14.53","shortMessageHtmlLink":"v4.14.53"}},{"before":"b56e047128116b1f88110bba1a9ec20548933202","after":null,"ref":"refs/heads/rjm/convert-to-text","pushedAt":"2024-05-13T20:22:29.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"}},{"before":"27eabc75953315cf84e9fbefeda7fd244e1dbb38","after":"63a9814130be0b0b0e7feea828c0d6ff573596a1","ref":"refs/heads/main","pushedAt":"2024-05-13T20:22:25.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Merge pull request #393 from socrata-platform/rjm/convert-to-text\n\nAdd a \"convert to text\" function to Reps","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2288679313\" data-permission-text=\"Title is private\" data-url=\"https://github.com/socrata-platform/soql-reference/issues/393\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/socrata-platform/soql-reference/pull/393/hovercard\" href=\"https://github.com/socrata-platform/soql-reference/pull/393\">#393</a> from socrata-platform/rjm/convert-to-text"}},{"before":"64435b47d20e3cf7fe4361b57cda802a064ec32b","after":"b56e047128116b1f88110bba1a9ec20548933202","ref":"refs/heads/rjm/convert-to-text","pushedAt":"2024-05-10T19:39:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Make it possible to recover the key from a cryptprovider","shortMessageHtmlLink":"Make it possible to recover the key from a cryptprovider"}},{"before":"10731f8c622ea7eb9e485bded7ec6d704e21ebbf","after":"64435b47d20e3cf7fe4361b57cda802a064ec32b","ref":"refs/heads/rjm/convert-to-text","pushedAt":"2024-05-10T00:37:01.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Add a \"convert to text\" function to Reps\n\nFor use in places where values get (sometimes implicitly) converted\nto text.","shortMessageHtmlLink":"Add a \"convert to text\" function to Reps"}},{"before":null,"after":"10731f8c622ea7eb9e485bded7ec6d704e21ebbf","ref":"refs/heads/rjm/convert-to-text","pushedAt":"2024-05-10T00:33:48.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Add a \"convert to text\" function to Reps\n\nFor use in places where values get (sometimes implicitly) converted\nto text.","shortMessageHtmlLink":"Add a \"convert to text\" function to Reps"}},{"before":"338e35abf1599e63b1ee07aa3c02fc8ae66b8a3f","after":"27eabc75953315cf84e9fbefeda7fd244e1dbb38","ref":"refs/heads/main","pushedAt":"2024-05-09T21:44:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"v4.14.52","shortMessageHtmlLink":"v4.14.52"}},{"before":"5f674515391f6c834a2c2225ca43b3001236279a","after":null,"ref":"refs/heads/rjm/revert-en-66000","pushedAt":"2024-05-09T21:44:49.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"}},{"before":"523e6240292c6b89d68b3aea3c935fce3f237435","after":"338e35abf1599e63b1ee07aa3c02fc8ae66b8a3f","ref":"refs/heads/main","pushedAt":"2024-05-09T21:43:50.000Z","pushType":"pr_merge","commitsCount":2,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Merge pull request #392 from socrata-platform/rjm/revert-en-66000\n\nRevert \"EN-66000: Don't accept id or version values in concat\"","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2288503732\" data-permission-text=\"Title is private\" data-url=\"https://github.com/socrata-platform/soql-reference/issues/392\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/socrata-platform/soql-reference/pull/392/hovercard\" href=\"https://github.com/socrata-platform/soql-reference/pull/392\">#392</a> from socrata-platform/rjm/revert-en-66000"}},{"before":null,"after":"5f674515391f6c834a2c2225ca43b3001236279a","ref":"refs/heads/rjm/revert-en-66000","pushedAt":"2024-05-09T21:37:15.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Revert \"EN-66000: Don't accept id or version values in concat\"\n\nThis reverts commit 4ba85884e08ff2c1680510c340eb5bbbdc49756a.","shortMessageHtmlLink":"Revert \"EN-66000: Don't accept id or version values in concat\""}},{"before":"d85706171a7892e2e07be42641f6387623f58026","after":"523e6240292c6b89d68b3aea3c935fce3f237435","ref":"refs/heads/main","pushedAt":"2024-04-25T23:28:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"v4.14.51","shortMessageHtmlLink":"v4.14.51"}},{"before":"6c641a8e294d8136413a7386ddc6d0f58a68cfab","after":null,"ref":"refs/heads/rjm/more-namespace-control","pushedAt":"2024-04-25T23:27:54.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"}},{"before":"c4f9a65e6d1ed318e6d3f307de0254457680559b","after":"d85706171a7892e2e07be42641f6387623f58026","ref":"refs/heads/main","pushedAt":"2024-04-25T23:27:51.000Z","pushType":"pr_merge","commitsCount":3,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Merge pull request #391 from socrata-platform/rjm/more-namespace-control\n\nAllow sqlizer implementations more control over column namespacing","shortMessageHtmlLink":"Merge pull request <a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2264586060\" data-permission-text=\"Title is private\" data-url=\"https://github.com/socrata-platform/soql-reference/issues/391\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/socrata-platform/soql-reference/pull/391/hovercard\" href=\"https://github.com/socrata-platform/soql-reference/pull/391\">#391</a> from socrata-platform/rjm/more-namespace-control"}},{"before":"4473a899a56f0139b7997d4da4c6fb5b5c831242","after":"6c641a8e294d8136413a7386ddc6d0f58a68cfab","ref":"refs/heads/rjm/more-namespace-control","pushedAt":"2024-04-25T23:15:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Consistency","shortMessageHtmlLink":"Consistency"}},{"before":null,"after":"4473a899a56f0139b7997d4da4c6fb5b5c831242","ref":"refs/heads/rjm/more-namespace-control","pushedAt":"2024-04-25T22:17:45.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"Allow sqlizer implementations more control over column namespacing\n\nBefore:\n* `SqlNamespaces` had an abstract method `rawDatabaseColumnBase`, which\n  was assumed to be a thing onto which further identifierish stuff could\n  be appended.\n\nNow:\n* `SqlNamespaces` has two methods, both named `rawDatabaseColumnName`.\n  The one with a \"suffix\" parameter should create a name which should\n  be in some sense \"like\" `rawDatabaseColumnName(dcn) + \"_\" + suffix`.","shortMessageHtmlLink":"Allow sqlizer implementations more control over column namespacing"}},{"before":"d089f5e410acdae7ccd9633cbe276ac974e32f2c","after":"c4f9a65e6d1ed318e6d3f307de0254457680559b","ref":"refs/heads/main","pushedAt":"2024-04-24T16:44:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"rjmac","name":null,"path":"/rjmac","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/753700?s=80&v=4"},"commit":{"message":"v4.14.50","shortMessageHtmlLink":"v4.14.50"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEWFw23AA","startCursor":null,"endCursor":null}},"title":"Activity · socrata-platform/soql-reference"}