The API call itself is free. But ANY code that is executed on a Databricks cluster (be it sql, python,...) is charged as it consumes hardware + DBU (except for community edition).
So to answer your question: yes, any sql will be charged.