CTE (Umumiy Jadval Ifodasi, WITH) bilan biror narsa yozdingizmi?

Ha, men SQL so'rovlarida CTE (Common Table Expression) dan foydalanib, murakkab so'rovlarning o'qilishi va tuzilishini yaxshiladim. CTE vaqtinchalik nomlangan jadvalni belgilash imkonini beradi, uni asosiy so'rov ichida ishlatish mumkin.

CTE dan foydalanish misoli:

WITH recent_orders AS (
    SELECT order_id, customer_id, order_date
    FROM orders
    WHERE order_date > CURRENT_DATE - INTERVAL '30 days'
)
SELECT customer_id, COUNT(order_id) AS orders_count
FROM recent_orders
GROUP BY customer_id;

Go tilida, bu so'rovni database/sql yoki sqlx kabi ma'lumotlar bazasi bilan ishlash kutubxonalar bilan birga ishlatish qulay, shunchaki bu so'rovni satr sifatida o'tkazish orqali.