SingleStore does not have the concept of schemas, rather different databases are created instead of a single database with different schemas. This has an impact on the push down of queries that span different databases. This also limits the pushdown of queries on tables that are combined with cached tables.
Thank you for raising the idea. Unfortunately, this is currently not on the product roadmap and we are unlikely to address this anytime soon. Tagging this as an unlikely to implement.