I would like to be able do the following:

jdbcClient.sql("SELECT * FROM table1 WHERE column1 = ?")
    .param(123)
    .fetchSize(123) // <<<< New
    .maxRows(123) //  <<<< New
    .queryTimeout(123) //  <<<< New
    .query()
    .singleRow();

Currently I have to manually create a new JdbcClient every time the default settings are not suitable.

I can supply a PR if above is a desired addition.

Comment From: jhoeller

This goes along nicely with our current work toward #32501 and in particular #26840 where we internally derive a JmsTemplate with different settings per operation. We could use a similar approach for JdbcClient with those JdbcTemplate settings.

At this point I expect to apply the same approach as in JmsClient which is to be committed early next week. From that perspective, there is no need for a PR. Thanks for the offer, in any case :-)