Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature]: interactive sql code block #142

Open
eitsupi opened this issue Jan 30, 2024 · 1 comment
Open

[Feature]: interactive sql code block #142

eitsupi opened this issue Jan 30, 2024 · 1 comment
Labels
p: low Address issue when time permits t: feature-request Request the addition of a new feature
Milestone

Comments

@eitsupi
Copy link

eitsupi commented Jan 30, 2024

Feature Description

Thank you for working on this wonderful extension.

Since duckdb seems to work quite well, I thought it would be great if we could implement an interactive SQL code block.
It is easier to define tables (data frames) in R compared to SQL, so it would be useful to prepare data on the R side and execute the query in SQL side.

@coatless coatless added t: feature-request Request the addition of a new feature p: low Address issue when time permits labels Jan 30, 2024
@coatless
Copy link
Owner

Hi @eitsupi, we're likely going to move to having some level of support for DBI-compliant packages that likely follows the usual Quarto approach:

```{webr-sql}
--| connection: db

SELECT * FROM "hello";
```

This is a longer-term feature.

@coatless coatless added this to the 4.x milestone Jan 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
p: low Address issue when time permits t: feature-request Request the addition of a new feature
Projects
None yet
Development

No branches or pull requests

2 participants