| # ISA 401 Job Scout Chat: ask questions, get SQL, a table, or a chart back | |
| library(querychat) | |
| con = DBI::dbConnect(RSQLite::SQLite(), "data/scout.db") | |
| client = ellmer::chat_openai( | |
| model = "gpt-5.6-luna", | |
| params = ellmer::params(reasoning_effort = "none") | |
| ) | |
| qc = querychat( | |
| con, "scout_postings", | |
| client = client, | |
| tools = c("filter", "query", "visualize"), # visualize: charts in the chat (needs ggsql) | |
| greeting = "Ask me about the 1,891 job postings ChatISA Job Scout collected." | |
| ) | |
| qc$app_obj() | |