Sql Cells are Awsome

Show and tell
1

It’s really cool actually :blush:
https://observablehq.com/@neocarto/sql-cells-are-awsome

2

This is interesting. I did some testing first with Inputs.table on result and there was no need to use the .toArray() method on it; it is result-aware:

image
image937×233 15.3 KB

Then I said, :thinking:. I wonder if plot is result-aware as well? Sure enough, it is:

image
image981×572 29 KB

3

Yes, both Observable Plot and Observable Inputs support Arrow Tables as data sources. Plot uses columnar data internally, in fact. Both libraries also support any iterable of rows as a data source.