Command output for query()?

[sjenriquez]

Hi!

Is it possible to get the output from non-SELECT commands when using Connection.query()? In my application, I'm accepting a SQL command and passing it to query() like:

connection.query(command, {
		params: parameters,
		cursor: true,
		fetchCount: 250,
	});

Then I process like:

while ((row = await cursor?.next())) {
	// do some processing or rows
}

It would be great if I could get the output for non-SELECT commands with something like cursor.output().

[erayhanoglu]

Which sql command are you trying to execute? If you are not sure type of sql command you can simple use .execute() method.

[sjenriquez]

Thanks for the quick reply! I looked at .execute() but from what I saw that doesn't allow a parameterized query. We are passing any sql command to .query(), which is working, but we don't get the output like INSERT 5 or DELETE 1.

[erayhanoglu]

You can use .query() method for any query (select, insert, delete etc). However "cursor" option is only available for queries which returns rows. This is the nature of all RDBMS databases. As you will agree, delete or insert queries does not return rows.

[sjenriquez]

Thanks, I got this working as desired by only running select commands with a cursor and building the output as an array with other non-select commands like [`${qr.command} ${qr.rowsAffected}`].