async def scalar(self, query, as_tuple=False):
query = self._swap_database(query)<EOL>return (await scalar(query, as_tuple=as_tuple))<EOL>
Get single value from ``select()`` query, i.e. for aggregation.

        :return: result is the same as after sync ``query.scalar()`` call