What does AWS SQS (Simple Queue Service) involve, and could you provide a comprehensive explanation of its functionalities, use cases, and how it contributes to facilitating scalable and reliable message queuing within the Amazon Web Services ecosystem?