My function is not filling the value to return in function

Question

I am developing a test API using nodejs and Firebird and after a lot of struggle I was able to make the bank consultation work. However I am not able to make the function return the values that were located in the query. When I display via the.log() console I can view the results.

const client = require('../database/index');

var options = require('../database/config');

var resultado;

function setResultado(pResultado) {
    resultado = pResultado;
}

function getResultado() {
    return resultado;
}

const rows = async () => {
  try{
      
    try{
        var pool = client.pool(5, options);

        pool.get(function(err, db) {

            try{
                db.query("SELECT * FROM UCTABUSERS where UCIDUSER = 1", function(err, result) {
                setResultado(result);
                db.detach();
                });
            }catch{
                console.log(err);
                return err;
            }
        });

        pool.destroy();
        
        return getResultado();

    }catch{
        return 'Não foi possivel abrir a conexão';
    }
    }catch{
        return "Não foi possivel conectar ao banco de dados";
    }
};

const User = rows();

module.exports = User;

Anyone have any suggestions to solve my problem? Thanks in advance! (P.S.: I’m a beginner in javascript, I don’t know much yet)

There is the code where I call the route. But I even tested the route, when I put a string any works. The problem is that when I am using the Return getResulted(); already at the end of the Try, the getResulted() is returning undefined, it is as if within the pool function it existed and I was filled and outside was not.

router.get('/register', async (req,res) => {
    try{
        const user = await Users;
        return res.send({user});
    }catch{
        res.status(400).send({error : 'Falha ao registrar'})
    }
});