Allow for overwriting of query segements

[nrwiersma]

Hey,

Came across a use case that, while maybe possible, is probably not great. I am busy building large query objects, and in an inheritance case, I want to overwrite the selects. I do understand that this is a little bit of an edge case. It would good however to have select and addSelect which will allow for this. select would overwrite the selects and addSelect would append.

Later.

[adambanaszkiewicz]

Maybe select() method should be same as is, but add method replaceSelect(). IMO basic methods should be as simple as possible, and methods that came outside the basic functionality can have more complicated names, because these methods will be used rare, and developers to use them almost always came to DOC to read how do this.

Also, You can always write Your own QueryBuilder and QueryBuilderFactory and extends this code, and add methods that You need, in the way you need. There is realy more to extends, this code is open for modifications by extending :)

[nrwiersma]

The other option is to use default parameters, like an $overwrite = false parameter.

I hear you though, I am not opposed to inheriting, especially cause this is an edge case.

You are welcome to close this issue.

[adambanaszkiewicz]

Can You describe little this idea with parameter?

[nrwiersma]

Just looked at the code again, it wouldn't work because select is using func_get_args(). Your method would be better in this case.

[adambanaszkiewicz]

I add remove*() methods, that allows to remove each query segment, like:

removeSelects(), removeWheres(), removeLimit(), etc.