Function: Question answered from text

SELECT
  semantic_ask (
    'The sky is blue because of Rayleigh scattering',
    'What color is the sky?'
  )

Function: Price extracted via question

SELECT
  semantic_ask (
    'The product costs $99.99 and ships within 3 days',
    'How much does it cost?'
  )

Infix ASK: extracts answer from text

WITH
  t AS (
    SELECT
      'Einstein developed the theory of relativity' AS fact
  )
SELECT
  fact ASK 'Who developed this?'
FROM
  t

Function with concat: compound first arg

SELECT
  semantic_ask (
    'Albert' || ' ' || 'Einstein discovered relativity',
    'Who discovered relativity?'
  )

Function with concat: column concatenation

WITH
  t AS (
    SELECT
      'Paris' AS city,
      'France' AS country
  )
SELECT
  semantic_ask (
    city || ' is the capital of ' || country,
    'What is the capital?'
  )
FROM
  t

Function with UPPER: nested function call

SELECT
  semantic_ask (UPPER('the sky is blue'), 'What color?')