@spec fragment_prompt(String.t(), String.t(), String.t() | nil, String.t()) ::
  String.t()

Build the user prompt for explaining a fragment in context of the full query.

The fragment is the portion the user highlighted/selected. The full query provides necessary context so the LLM can explain even isolated terms (e.g., a single JOIN clause, a HAVING condition, or a function call).

Parameters

• fragment - The selected fragment to explain
• full_sql - The complete query for context
• source_context - Optional source context string
• fence - Markdown fence label for the statement blocks, from Lotus.AI.Prompts.AdapterNotes.fence_label/1

@spec system_prompt(atom()) :: String.t()

Generate system prompt for query explanation.

Parameters

• database_type - Database type (e.g., :postgres, :mysql, :sqlite)

@spec user_prompt(String.t(), String.t() | nil, String.t()) :: String.t()

Build the user prompt for a full query explanation.

Parameters

• sql - The full query to explain
• source_context - Optional source context string
• fence - Markdown fence label for the statement block, from Lotus.AI.Prompts.AdapterNotes.fence_label/1