Use Gemini 3.0 Pro with BigQuery.

bq_gemini3_preview.sql

# Just replace <project_id> in the endpoint argument with your own project to run this query!
SELECT 
  title,
  medium,
  AI.GENERATE(
    'Write a 1-sentence dramatic backstory for this object: ' || title || ' made of ' || medium,
    endpoint => 'https://aiplatform.googleapis.com/v1/projects/<project_id>/locations/global/publishers/google/models/gemini-3-pro-preview'
  ) AS ai_story
FROM 
  `bigquery-public-data.the_met.objects`
WHERE 
  department = 'Arms and Armor';