llm_filter

SELECT *
FROM VALUES
    (1, 'Eco-friendly bamboo toothbrush made from sustainable materials'),
    (2, 'Plastic water bottle made from recycled content'),
    (3, 'Organic cotton t-shirt with natural dyes')
AS t(product_id, product_description)
WHERE llm_filter(
    {'model_name': 'gpt-4o'},
    {
      'prompt': 'Is this product description eco-friendly?',
      'context_columns': [{'data': product_description, 'name': 'description'}]
    }
);

SELECT product_id, product_name, image_url
FROM VALUES
    (1, 'Premium Headphones', 'https://images.unsplash.com/photo-1505740420928-5e560c06d30e?w=400', 150.00),
    (2, 'Gaming Mouse', 'https://images.unsplash.com/photo-1527814050087-3793815479db?w=400', 75.00)
AS t(product_id, product_name, image_url, price)
WHERE llm_filter(
    {'model_name': 'gpt-4o'},
    {
      'prompt': 'Is this a high-quality professional product photo?',
      'context_columns': [
        {'data': image_url, 'type': 'image'},
        {'data': product_name}
      ]
    }
)
AND price > 50;

SELECT audio_id, customer_id, file_path
FROM VALUES
    (1, 101, '/data/audio/call_01.wav'),
    (2, 102, '/data/audio/call_02.wav')
AS t(audio_id, customer_id, file_path)
WHERE llm_filter(
    {'model_name': 'gpt-4o'},
    {
      'prompt': 'Does this call mention cancelling a subscription? Answer true or false.',
      'context_columns': [{
        'data': file_path,
        'type': 'audio',
        'transcription_model': 'whisper-1'
      }]
    }
);

SELECT *
FROM VALUES
    (1, 'Eco-friendly bamboo toothbrush made from sustainable materials'),
    (2, 'Plastic water bottle made from recycled content'),
    (3, 'Organic cotton t-shirt with natural dyes')
AS t(product_id, product_description)
WHERE llm_filter(
    {'model_name': 'gpt-4o'},
    {'prompt': 'Is this product description eco-friendly?', 'context_columns': [{'data': product_description, 'name': 'description'}]}
);

SELECT *
FROM VALUES
    (1, 'Solar-powered garden lights with LED technology'),
    (2, 'Disposable plastic cups for parties'),
    (3, 'Reusable stainless steel water bottle')
AS t(product_id, product_description)
WHERE llm_filter(
    {'model_name': 'gpt-4o'},
    {'prompt_name': 'eco-friendly-check', 'context_columns': [{'data': product_description, 'name': 'description'}]}
);

WITH sample_products AS (
    SELECT *
    FROM (VALUES
        (1, 'Eco-friendly bamboo phone case', 'Made from sustainable bamboo'),
        (2, 'Plastic keyboard covers', 'Protective covers for keyboards'),
        (3, 'Biodegradable cleaning supplies', 'Plant-based cleaning products')
    ) AS t(product_id, product_name, product_description)
),
filtered_products AS (
    SELECT product_id, product_name, product_description
    FROM sample_products
    WHERE llm_filter(
        {'model_name': 'gpt-4o', 'secret_name': 'openai_key'},
        {'prompt': 'Is this product description eco-friendly?', 'context_columns': [{'data': product_description, 'name': 'description'}]}
    )
)
SELECT * FROM filtered_products;

WITH sample_reviews AS (
    SELECT *
    FROM (VALUES
        (1, 'This product exceeded my expectations! Amazing quality and fast delivery.'),
        (2, 'Terrible experience. Product broke after one day and customer service was unhelpful.'),
        (3, 'Good value for money. Works as expected and arrived on time.'),
        (4, 'Outstanding! Best purchase I have made this year. Highly recommended!')
    ) AS t(review_id, review_content)
),
relevant_reviews AS (
    SELECT review_id, review_content
    FROM sample_reviews
    WHERE llm_filter(
        {'model_name': 'gpt-4o'},
        {'prompt': 'Does this review content contain a positive sentiment?', 'context_columns': [{'data': review_content, 'name': 'content'}]}
    )
)
SELECT * FROM relevant_reviews
WHERE LENGTH(review_content) > 50;