Is there any way to remove the select portion of a query? IE the from/joins/where are stable but I want to change between select count(*) and select (fields). I'm avoiding fetchCount and using selectCount because fetchCount doesn't handle duplicated field names, and I don't want to do 'as' for every id field.
I've tried using the SelectQuery<T> but there doesn't seem to be a way to 'deep' copy it. It's always points back to the same parameter. So once you've added something (like addSelect) there's no way to remove it and add a different select. I've managed to get around this using a Supplier<T> but then it re-creates the statement each time, which seems inefficient. Thanks! -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
