text_to_sql

The morph_lib.ai package has been deprecated since v0.1.5 to reduce the size of the morph-data package.It is planned to be provided in the form of an external adapter in the future.

Generates SQL from a given prompt.

# 📦 Package: morph_lib.ai.openai.code_generation
# 🛠️ Function: text_to_sql

def text_to_sql(
    prompt: str,
    api_key: str,
    table_names: List[str],
    model: Optional[str] = "gpt-4o",
    connection: Optional[str] = None,
    schema_name: Optional[str] = None,
) -> TextConversionResponse:

# 📦 Package: morph_lib.ai.anthropic.code_generation
# 🛠️ Function: text_to_sql

def text_to_sql(
    prompt: str,
    api_key: str,
    table_names: List[str],
    model: Optional[str] = "claude-3-5-haiku-latest",
    max_tokens: Optional[int] = 1024,
    connection: Optional[str] = None,
    schema_name: Optional[str] = None,
) -> TextConversionResponse:

# 📦 Package: morph_lib.ai.azure.code_generation
# 🛠️ Function: text_to_sql

def text_to_sql(
    prompt: str,
    api_key: str,
    table_names: List[str],
    azure_endpoint: str,
    deployment_name: Optional[str] = "gpt4",
    api_version: Optional[str] = "2024-10-01-preview",
    connection: Optional[str] = None,
    schema_name: Optional[str] = None,
) -> TextConversionResponse:

# 📦 Package: morph_lib.ai.groq.code_generation
# 🛠️ Function: text_to_sql

def text_to_sql(
    prompt: str,
    api_key: str,
    table_names: List[str],
    model: Optional[str] = "llama-3.1-70b-versatile",
    connection: Optional[str] = None,
    schema_name: Optional[str] = None,
) -> TextConversionResponse:

Parameters

These are the parameters for OpenAI. Set the authentication parameters for other models as appropriate from the function definitions above.

string

required

Prompt

string

required

API key for using the LLM model

list

required

List of table names used for generation

string

LLM model to use

string

Connection used for generation

string

Schema name used for generation

Example

from morph_lib.ai.openai import text_to_sql
import os

@morph.func
def func_name(context):
    sql = text_to_sql(
		prompt,
		os.environ["OPENAI_API_KEY"],
		["user"],
		"gpt-4o",
	)
	return execute_sql(sql)

context text_to_plotly

Framework

SQL

Python

morph_lib.database

morph_lib.api

morph_lib.stream

CLI

Deprecated

text_to_sql

Parameters

Example

​Parameters

​Example

Parameters

Example