Cross docs data exchange as livestream by vsv: CSV Files as Virtual Tables in SQLite

[Vladimir-Va]

Hello, the request to exchange data between documents is quite popular.
Currently we can import csv from a text file, but this does not allow us to receive data in real time (or at least automatically), without user interaction.
Because Under the hood of Grist there is SQLite, I found an interesting extension
https://github.com/nalgeon/sqlean/blob/main/docs/vsv.md
Provides virtual table for working directly with CSV files, without importing data into the database. Useful for very large datasets.
This opens up interesting possibilities for delivering unique experiences to users.

1. .CSV URL Export not for public tables
   You can check user access inside Grist without having to grant public access to read the data source.
2. vsv allows you to create a column structure, thus allowing you to dynamically change the table structure in the destination document based on the table data in the source document. And id.source=$id in this case.
3. vsv will allow you to safely integrate third-party url-csv livestream files without being tied to a pre-configured document structure.
4. Because the data in the destination table is static (not as Summary Tables), this will allow you to reuse this data in LOOKUP formulas, and use standart Access rules.