Formatea, Embellece y
Construye Consultas SQLsin Fricción.

INSERT INTO user_preferences (user_id, theme, notifications, updated_at)
VALUES (1042, 'dark', true, CURRENT_TIMESTAMP)
ON CONFLICT (user_id)
DO UPDATE SET
  theme = EXCLUDED.theme,
  notifications = EXCLUDED.notifications,
  updated_at = CURRENT_TIMESTAMP;

WITH ranked_products AS (
  SELECT
    id, title, category_id, price,
    ROW_NUMBER() OVER (PARTITION BY category_id ORDER BY price DESC) AS rank_in_category
  FROM products
  WHERE status = 'published'
)
SELECT * FROM ranked_products
WHERE rank_in_category <= 3
ORDER BY category_id, rank_in_category;

WITH order_summary AS (
  SELECT
    customer_id,
    COUNT(id) AS order_count,
    SUM(total_amount) AS lifetime_value
  FROM orders
  WHERE payment_status = 'settled'
  GROUP BY customer_id
)
SELECT c.id, c.full_name, c.email, s.order_count, s.lifetime_value
FROM customers c
INNER JOIN order_summary s ON s.customer_id = c.id
WHERE s.lifetime_value >= 1000.00
ORDER BY s.lifetime_value DESC;