You can use ai_query function to achieve this in SQL. It takes an LLM endpoint and a prompt as input.
Here's an example with DBRX and a specific Indian manufacturing industry-related prompt.
create
or replace function ai_create_table_metadata (table...