The ideal service for the described scenario is Amazon Athena, as it provides the ability to perform interactive analyses and run SQL-like queries directly on data residing in the cloud storage service without the need to manage servers, thereby offering a serverless experience. Amazon Redshift is designed for complex and large-scale data warehousing operations and is not optimized for serverless ad-hoc queries without data movement. AWS Glue focuses on extract, transform, and load (ETL) jobs and data preparation tasks, which are more complex than required for simple SQL querying. Amazon QuickSight is a business intelligence service that specializes in creating visualizations and dashboards, rather than serving SQL queries directly on raw data.