Django raw SQL queries for complex operations

                  from django.db import connection
from blog.models import Post


def get_top_authors(limit=10):
    """Get authors with most published posts using raw SQL."""
    query = """
        SELECT
            u.id,
            u.username,
            COUNT(p.id) as post_count
        FROM auth_user u
        INNER JOIN blog_post p ON u.id = p.author_id
        WHERE p.status = %s
        GROUP BY u.id, u.username
        ORDER BY post_count DESC
        LIMIT %s
    """

    with connection.cursor() as cursor:
        cursor.execute(query, ['published', limit])
        columns = [col[0] for col in cursor.description]
        return [dict(zip(columns, row)) for row in cursor.fetchall()]


def get_monthly_stats():
    """Use raw() to get Post objects with aggregations."""
    query = """
        SELECT
            id,
            title,
            author_id,
            DATE_TRUNC('month', published_at) as month
        FROM blog_post
        WHERE status = %s
        ORDER BY published_at DESC
    """

    return Post.objects.raw(query, ['published'])