Function: Price extracted

SELECT
  semantic_extract ('The price is $49.99 per unit', 'price')

Function: Email extracted

SELECT
  semantic_extract ('Contact John Smith at john@company.com', 'email')

Function: Order number extracted

SELECT
  semantic_extract (
    'Order shipped ref 12345 on Monday',
    'order number'
  )

Infix EXTRACTS: time extracted from text

WITH
  t AS (
    SELECT
      'Meeting with CEO scheduled for 3pm' AS msg
  )
SELECT
  msg EXTRACTS 'time'
FROM
  t

Infix EXTRACTS: product name extracted

WITH
  t AS (
    SELECT
      'Product: iPhone 15 Pro Max - great camera!' AS review
  )
SELECT
  review EXTRACTS 'product name'
FROM
  t