Plugin Hooks for "compile to SQL" languages
Open
Nobody has claimed this yet.
plugins
- Dominant language
- Python
- Stars
- 11.5k
- Forks
- 904
- Avg merge
- 4d 17h
- Merged PRs (30d)
- 18
Description
There's a ton of tools/languages that compile to SQL, which may be nice in Datasette. Some examples:
- Logica https://logica.dev
- PRQL https://prql-lang.org
- Malloy, but not sure if it works with SQLite? https://github.com/malloydata/malloy
It would be cool if plugins could extend Datasette to use these languages, in both the code editor and API usage.
A few things I'd imagine a datasette-prql or datasette-logica plugin would do:
prql=instead ofsql=- Code editor support (syntax highlighting, autocomplete)
- Hide/show SQL
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing Datasette's existing plugin support, code editor, and API entry points. Done means a plugin can expose a compile-to-SQL language such as PRQL or Logica, support its editor behavior, accept its query parameter, and control whether generated SQL is shown.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- api, tooling
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100