René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Support PostgreSQL CREATE TABLE LIKE","articleBody":"The following create table statement\r\n\r\n```sql\r\nCREATE TABLE changes (\r\n    ranked INT NOT NULL\r\n);\r\n\r\nCREATE TABLE changes_ranked (\r\n    LIKE changes INCLUDING ALL,\r\n    rank_by_effect_size INT NOT NULL,\r\n    rank_by_abs_percent_change INT NOT NULL\r\n);\r\n\r\n\r\n-- name: AllRanked :many\r\nSELECT * FROM changes_ranked;\r\n```\r\n\r\nproduces model\r\n```go\r\ntype ChangesRanked struct {\r\n       RankByEffectSize       int32\r\n       RankByAbsPercentChange int32\r\n}\r\n```\r\nColumns from the `changes` table are ignored.\r\n\r\n(Aside: I encountered this while trying to work around #159. The `changes_ranked` table is an attempt to materialize what would have been a subquery.)","author":{"url":"https://github.com/mmcloughlin","@type":"Person","name":"mmcloughlin"},"datePublished":"2020-05-12T06:57:35.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/481/sqlc/issues/481"}