Hugo has an awesome code block styling https://gohugo.io/content-management/syntax-highlighting/
for exampl
SELECT *
FROM table
WHERE column =1
I was just wondering if it possible to select custom color pallete .
Read that page you linked 
There are several styles included that you can compile. Find one you like, compile the styles, then change them to your liking.
hugo gen chromastyles --style=monokai > syntax.css
in addition to the excellent resources linked by @davidsneighbour, in general pygments compatible css “just works” also as drop-in stylesheets. Pygments has been around for a long time, so you might well find even more variety of stylesheets to suit your needs by looking for those too.
[edit:] I say in general, there are some minor incompatibilities, but for the large part it pretty much works.