Is it possible to create a table in Supabase programmatically using the Python client?

Question

I would like to create a table on Supabase programmatically. Is this possible?

Using this code:

from supabase_client import supabase
SQL statements to create tables
sql_create_tables = """--sql
CREATE TABLE IF NOT EXISTS biomarker (
    name VARCHAR(255) PRIMARY KEY,
    unit VARCHAR(100) NOT NULL,
    reference_range_min VARCHAR(100),
    reference_range_max VARCHAR(100),
    description TEXT
);
"""
Execute raw SQL to create the tables
response = supabase.rpc("execute_sql", {"query": sql_create_tables}).execute()
print(response)

However, I am getting this error when running this code:

postgrest.exceptions.APIError: {'code': 'PGRST202', 'details': 'Searched for the function public.execute_sql with parameter query or with a single unnamed json/jsonb parameter, but no matches were found in the schema cache.', 'hint': None, 'message': 'Could not find the function public.execute_sql(query) in the schema cache'}

Is it just not possible to create a table programmatically on Supabase?