Generate SQL Server Test Data

CREATE TABLE [customers] (
    [id]         INT PRIMARY KEY,
    [name]       NVARCHAR(120) NOT NULL,
    [email]      NVARCHAR(255) UNIQUE NOT NULL,
    [tier]       NVARCHAR(20) DEFAULT N'free',
    [created_at] DATETIME2 DEFAULT GETDATE()
);

CREATE TABLE [orders] (
    [id]          INT PRIMARY KEY,
    [customer_id] INT NOT NULL FOREIGN KEY REFERENCES [customers]([id]),
    [total]       DECIMAL(10,2) NOT NULL,
    [status]      NVARCHAR(20) DEFAULT N'pending',
    [placed_at]   DATETIME2 DEFAULT GETDATE()
);

-- Bulk load via BULK INSERT (fastest for SQL Server)
BULK INSERT [customers]
FROM '/tmp/customers.csv'
WITH (FORMAT = 'CSV', FIRSTROW = 2, FIELDTERMINATOR = ',');