🚧 Subqueries

🚧 Coming soon: Scalar subqueries in SELECT, correlated subqueries in WHERE, and inline views in FROM.

-- Placeholder example
SELECT o.OrderID,
       (SELECT COUNT(*) FROM dbo.OrderLines l WHERE l.OrderID = o.OrderID) AS Items
FROM dbo.Orders o;