How to cache native SQL?

Question

Doctrine ORM

https://www.doctrine-project.org/projects/doctrine...
I only see DQL caching here.
How to cache this?

$select = '
                SELECT * FROM users ' . $alias . '
                ORDER BY ' . $alias. '.created_at ASC
            ';

            $rsm = new ResultSetMappingBuilder($this->entityManager);
            $rsm->addRootEntityFromClassMetadata(User::class, $this->usersAlias);

            $query = $this->entityManager->createNativeQuery($select, $rsm);

            return $query->getResult();

Answer 1

$cache_id = md5($select);