Asyncpg's `fetchmany()` is not exposed in any QuartDB methods

[Hoid]

Hi,

I need to access asyncpg's fetchmany() functionality. That is, a fetchall() but providing the method with a list of ValueObjects rather than just one. This is supported in the execute_many() method for a regular Connection, which exposes the functionality of asyncpg's executemany() and allows me to provide it a list of ValueObjects, but there is no fetch_many() method in QuartDB. Given the underlying functionality for this in asyncpg is there I was hoping I could get the fetch_many() method implemented. If you need me to create a PR to do so I can try, but I figured y'all could implement it faster than I could 😅.

[Hoid]

Oh, just looked into this and it looks like executemany() in the underlying db API doesn't support returning any resultset (https://peps.python.org/pep-0249/#executemany). That definitely complicates things.

Is there any way we can have the library build the query string, use execute() instead of executemany(), and instead of passing in a DML statement pass in regular SQL while doing parameter validation (to prevent SQL injection) ourselves? That's the only way I can think of to get around the limitation that executemany() requires you to use a DML statement (which means no SELECT statements). Perhaps the underlying db engine exposes some method for doing parameter validation to prevent SQL injection, so we don't have to reinvent the wheel?