Description

Implement the sql command for querying S3 objects using S3 Select.

Requirements

• Execute SQL queries on CSV, JSON, or Parquet files stored in S3
• Stream query results to stdout
• Requires S3 Select feature support

Acceptance Criteria

• rc sql <path> --query "SELECT * FROM s3object" - Execute SQL query
• Support input formats: CSV, JSON, Parquet (--input-format)
• Support output formats: CSV, JSON (--output-format)
• Support compression (GZIP, BZIP2) (--compression)
• Return EXIT_UNSUPPORTED_FEATURE (7) when S3 Select is not supported
• Support --force flag to bypass capability detection

Notes

This is a capability-dependent feature. S3 Select is not supported by all S3-compatible storage providers.