tamnd / tamnd/firepanda

M11: SQL, remaining IO, and 1.0

Open
#13 0 comments 0 reactions 0 assignees View on GitHub
area/io area/sql documentation milestone release
Dominant language
Mojo
Stars
1
Forks
0
PR merge metrics
PR metrics pending

Description

Tracking issue for **M11**. Specification: [`06-pandas-parity.md`](../blob/main/docs/specs/06-pandas-parity.md), [`09-quality-bar.md`](../blob/main/docs/specs/09-quality-bar.md).

### Scope

- [ ] `firepanda.sql()`, parsing into the **same logical plan** so the optimizer is shared
- [ ] `query()` and `eval()` for pandas parity
- [ ] An ADBC driver
- [ ] The remaining IO formats tagged `(M11)`: SQL, ORC, fixed width, Excel, HTML, XML, clipboard
- [ ] API review and freeze
- [ ] Complete docstring coverage with runnable examples
- [ ] The migration guide, **organized by pandas function name**

### Exit criteria

- [ ] All 22 TPC-H queries run correctly at SF10, with published timings against DuckDB, Polars and MojoFrame
- [ ] The public API is frozen and every exported symbol is documented
- [ ] Every checkbox in `06-pandas-parity.md` outside the explicitly post-1.0 sections is ticked

### On the migration guide

Somebody arriving at this library is holding a pandas program. The guide is a lookup table from what they have to what they write, and every divergence appears **on the row where it bites** rather than in a general caveats section nobody reads.

### Depends on

M7. Ideally M8 through M10, but 1.0 can ship without M10.

Contributor guide

Open the contributing guide

Research direction

This is a broad M11 tracking issue rather than a self-contained task. Start with docs/specs/06-pandas-parity.md and docs/specs/09-quality-bar.md, then review the M7 dependency and the listed SQL, IO, API, documentation, migration-guide, and TPC-H work. Done means the stated exit criteria are met, including the required parity checklist, API freeze, documentation, and benchmarks.

Written by the indexing model from the issue text.

Assessment

Tech stack
pandas, sql
Domain
data-engineering, databases, documentation, performance, testing
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.