René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Metadata types should be duckdb types","articleBody":"I noticed that metadata returned when POSTing to `/?default_format=JSONCompact` uses non-duckdb types and they are usually strings. Is this to be compatible with clickhouse?\r\n\r\nI think it would make more sense to use duckdb types (eg VARCHAR \u003e String), (INT \u003e Int32)\r\neg\r\n```sql\r\nselect 1\r\n```\r\n\r\nreturns\r\n\r\n```json\r\n{\r\n  \"meta\": [\r\n    {\r\n      \"name\": \"1\",\r\n      \"type\": \"Int32\"\r\n    }\r\n  ],\r\n  \"data\": [\r\n    [\r\n      \"1\"\r\n    ]\r\n  ],\r\n  \"rows\": 1\r\n}\r\n```\r\n\r\n\r\n```sql\r\nWITH l33t_uuid AS (\r\n  SELECT 'deadbeef-1337-4b1d-8008-0123456789ab'::UUID AS uuid_value\r\n)\r\nSELECT\r\n  uuid_value::VARCHAR AS uuid_string,\r\n  uuid_value AS uuid_uuid,\r\n  typeof(uuid_value::VARCHAR) AS uuid_string_type,\r\n  typeof(uuid_value) AS uuid_uuid_type\r\nFROM l33t_uuid;\r\n```\r\nReturns\r\n```json\r\n{\r\n  \"meta\": [\r\n    {\r\n      \"name\": \"uuid_string\",\r\n      \"type\": \"String\"\r\n    },\r\n    {\r\n      \"name\": \"uuid_uuid\",\r\n      \"type\": \"String\"\r\n    },\r\n    {\r\n      \"name\": \"uuid_string_type\",\r\n      \"type\": \"String\"\r\n    },\r\n    {\r\n      \"name\": \"uuid_uuid_type\",\r\n      \"type\": \"String\"\r\n    }\r\n  ],\r\n  \"data\": [\r\n    [\r\n      \"deadbeef-1337-4b1d-8008-0123456789ab\",\r\n      \"deadbeef-1337-4b1d-8008-0123456789ab\",\r\n      \"VARCHAR\",\r\n      \"UUID\"\r\n    ]\r\n  ],\r\n  \"rows\": 1\r\n}\r\n```\r\n","author":{"url":"https://github.com/tarasglek","@type":"Person","name":"tarasglek"},"datePublished":"2025-01-14T14:31:52.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":16},"url":"https://github.com/28/httpserver/issues/28"}