René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Support composite types","articleBody":"### `CREATE TYPE`\r\n\r\n```sql\r\nCREATE TYPE myarg as (\r\n    id integer,\r\n    name text\r\n);\r\n\r\n-- name: BasicQuery :one\r\nselect $1::myarg;\r\n```\r\n\r\n### Automatic table types\r\n\r\nhttps://www.postgresql.org/docs/current/rowtypes.html\r\n\r\n\u003e Whenever you create a table, a composite type is also automatically created, with the same name as the table, to represent the table's row type. For example, had we said:\r\n\r\n```sql\r\nCREATE TABLE authors (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\r\n\r\n-- name: AutomatiicType :many\r\nselect authors from authors;\r\n```","author":{"url":"https://github.com/kyleconroy","@type":"Person","name":"kyleconroy"},"datePublished":"2023-09-22T17:09:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/2760/sqlc/issues/2760"}