To get the most out of HCS, you should utilize it as your definitive trust record while depending on a dedicated indexer to manage your read operations. Because HCS functions as a securely ordered and tamper-resistant log of events rather than a conventional query engine, standard database commands such as SELECT and JOIN are not applicable. For a deeper understanding of this approach, please review the detailed article written by @TMCC_Patches available at https://hedera.com/blog/how-to-unlock-the-full-potential-of-hcs-and-why-it-is-not-a-database/