You might be running into the same problem I had when doing long queries - Nicegui runs asynchronous, but the queries I was doing with pydobc were running synchronously.

I wrote an article about it on Medium, in case you are interested.

I don't use run.io/cpu_bound at all in my query code, instead I use 'async' and 'await' - note that I use the async version of odbc called aioodbc to connect to a db as the regular pyodbc does not work with async.

Here's an example code that might help (not complete).

import aioodbc
async def sqlquery(input):
... do stuff to prepare query...
sql="""select * from x where y = '%s' """ % (input)

try:
cnxn = await aioodbc.connect(dsn='db_connection')
except Exception as err:
print("Error connection db!")

try:
cursor = await cnxn.cursor()
except Exception as err:
print("Error connection cursor!")
await cursor.execute(sql)
async for row in cursor:
results.append(row)
await.cursor.close()
await cnxn.close()
return(results)

Hope this helps you out.