code: async def scalar(self, query, *multiparams, **params):
          
          res = await self.execute(query, *multiparams, **params)
          return (await res.scalar())
docs: Executes a SQL query and returns a scalar value.