Crate limbo_csv 

Port of SQLite’s CSV virtual table extension: https://www.sqlite.org/csv.html

This extension allows querying CSV files as if they were database tables, using the virtual table mechanism.

It supports specifying the CSV input via a filename or raw data string, optional headers, and customizable schema generation.

Example usage:

CREATE VIRTUAL TABLE temp.my_csv USING csv(filename='data.csv', header=yes);
SELECT * FROM my_csv;

Parameters:

• filename — path to the CSV file (mutually exclusive with data=)
• data — inline CSV content as a string
• header — whether the first row contains column names; accepts yes/no, on/off, true/false, or 1/0
• columns — number of columns
• schema — optional custom SQL CREATE TABLE schema

Functions

register_extension^⚠