import openai
import os

openai.api_key = os.getenv("OPENAI_API_KEY")

def call_gpt4o(prompt):
    response = openai.ChatCompletion.create(
        model="gpt-4o",
        messages=[
            {"role": "system", "content": "You are a helpful assistant that converts natural language into SQL queries using the provided schema."},
            {"role": "user", "content": prompt}
        ],
        temperature=0.2,
        max_tokens=512
    )
    return response['choices'][0]['message']['content']