db icon indicating copy to clipboard operation
db copied to clipboard

Support for HAVING?

Open martinrode opened this issue 7 years ago • 3 comments

Hi,

is there any way I can use sql HAVING clause with sqlbuilder? I only found GROUP BY in the source... HAVING is essential for the app I am building.

https://en.m.wikipedia.org/wiki/Having_(SQL)

Thanks for your effort, API of this package looks very promising and Go-ish!

Best Martin

martinrode avatar Dec 28 '18 08:12 martinrode

I agree. Found a comment referring to Having in: upper.io/db.v3/lib/sqlbuilder/interfaces.go

// Having(...interface{}) Selector

Having would be a valuable addition to this library.

arogozin avatar Mar 20 '19 14:03 arogozin

Same issue here, I'm wondering what's the reason not to have the Having clause?

vitaminwater avatar Mar 06 '21 06:03 vitaminwater

same here. Will this be added? For now I hacked it using the Amend function and string replacement.

jonrosner avatar Jul 12 '23 13:07 jonrosner