Problem Statement
QueryResult.Render (internal/database/query_result.go) currently loads all rows into memory and renders the full table using go-pretty. Running queries on large tables (e.g., SELECT * FROM large_table) can exhaust memory and crash the CLI.
Proposed Solution
Stream query results directly to stdout or the pager and process rows in batches instead of buffering the entire result set in memory.
Use Case
Users running large queries should be able to view results safely without risking OOM crashes.
Additional Context
This change would significantly improve reliability and scalability for real-world database usage.
Problem Statement
QueryResult.Render (internal/database/query_result.go) currently loads all rows into memory and renders the full table using go-pretty. Running queries on large tables (e.g., SELECT * FROM large_table) can exhaust memory and crash the CLI.
Proposed Solution
Stream query results directly to stdout or the pager and process rows in batches instead of buffering the entire result set in memory.
Use Case
Users running large queries should be able to view results safely without risking OOM crashes.
Additional Context
This change would significantly improve reliability and scalability for real-world database usage.