datasets:
  - from: github:github.com/spiceai/docs/pulls
    name: doc.pulls
    params:
      github_token: ${secrets:GITHUB_TOKEN}
    acceleration:
      enabled: true
    columns:
      - name: title
        full_text_search:
          enabled: true
          row_id:
            - id
      - name: body
        full_text_search:
          enabled: true

datasets:
  - from: github:github.com/spiceai/docs/pulls
    name: doc.pulls
    params:
      github_token: ${secrets:GITHUB_TOKEN}
    acceleration:
      enabled: true
    columns:
      - name: title
        full_text_search:
          enabled: true
          row_id:
            - id
      - name: body
        full_text_search:
          enabled: true

SELECT id, extra_column, score
FROM text_search(doc.pulls, 'search terms', body)
ORDER BY score desc
LIMIT 5

SELECT id, extra_column, score
FROM text_search(doc.pulls, 'search terms', body)
ORDER BY score desc
LIMIT 5

text_search(
  table STRING,              -- Dataset name (required)
  query STRING,              -- Search query expression (required)
  col STRING,                -- Column name to search in (required if multiple full text indices exist)
  limit INTEGER,             -- Maximum number of results to return (optional, default: all)
  include_score BOOLEAN      -- Whether to include relevance score (optional, default: TRUE)
)
RETURNS TABLE                -- The original table and an additional FLOAT column `score` (if `include_score`).

text_search(
  table STRING,              -- Dataset name (required)
  query STRING,              -- Search query expression (required)
  col STRING,                -- Column name to search in (required if multiple full text indices exist)
  limit INTEGER,             -- Maximum number of results to return (optional, default: all)
  include_score BOOLEAN      -- Whether to include relevance score (optional, default: TRUE)
)
RETURNS TABLE                -- The original table and an additional FLOAT column `score` (if `include_score`).