Support `HEAD` verb to get total count

[soedirgo]

Feature request

Is your feature request related to a problem? Please describe.

Getting a total count on e.g. /tables with GET can be expensive if we have a large number of tables. Currently this needs to be done through /query to get reasonable performance.

Describe the solution you'd like

Support HEAD verb starting with /tables to return total count in a Content-Range header.

Describe alternatives you've considered

n/a

[soedirgo]

cc @phamhieu