ATTACH 'ducklake:/tmp/test.db' AS test_db;
use test_db;

-- DuckDB JSON Column Issue Reproduction
-- This script demonstrates the "Unsupported user-defined type" error when trying to add JSON columns to existing tables

-- Test 1: JSON columns work fine during table creation
CREATE TABLE test_json_creation (
    id BIGINT,
    status VARCHAR,
    batch_id VARCHAR,
    validation_errors JSON
);

-- Verify the table was created successfully
PRAGMA table_info(test_json_creation);

-- Test 2: Adding JSON column to existing table fails
CREATE TABLE batch_transaction_finished (
    id BIGINT,
    status VARCHAR,
    batch_id VARCHAR
);

-- Verify initial table structure
PRAGMA table_info(batch_transaction_finished);

-- This statement will fail with "Invalid Input Error: Unsupported user-defined type"
ALTER TABLE batch_transaction_finished ADD COLUMN validation_errors JSON;

-- Expected error:
-- Invalid Input Error: Unsupported user-defined type

-- Test 3: Try other column types to confirm JSON is the issue
-- These should work fine:
ALTER TABLE batch_transaction_finished ADD COLUMN created_at TIMESTAMP;
ALTER TABLE batch_transaction_finished ADD COLUMN count_field INTEGER;
ALTER TABLE batch_transaction_finished ADD COLUMN description VARCHAR;

-- But JSON fails:
-- ALTER TABLE batch_transaction_finished ADD COLUMN metadata JSON;

-- Cleanup
DROP TABLE IF EXISTS test_json_creation;
DROP TABLE IF EXISTS batch_transaction_finished;

-- Summary:
-- - Creating tables with JSON columns works: ✓
-- - Adding JSON columns to existing tables via ALTER TABLE fails: ✗
-- - Adding other column types to existing tables works: ✓
-- - This appears to be a limitation/bug in DuckDB's ALTER TABLE JSON support