apache / apache/datafusion-sqlparser-rs

help wanted: extend cli example for batch processing

Open
#271 3 comments 0 reactions 0 assignees View on GitHub
question
Dominant language
Rust
Stars
3.5k
Forks
772
Avg merge
4d 9h
Merged PRs (30d)
17

Description

it looks like the sqlparser-rs can do what I need
- code of views is stored in mssqlserver
- json parser result should be stored into mssqlserver
- I wan't to be able to do this outside the rust environment, some compilation into a windows program is required to use this program also without installing rust on other machines

if it is to complicated to read the sql source from mssqlserver and to store the json result into mssqlserver it would be also possible:
- I can export from mssqlserver into sql text files
- sql files could be used as input for the cli
- json output should be stored into text files with the same BaseFileName (abc.sql => abc.json), but maybe into another folder
- I can import these json files into mssqlserver

Maybe the example cli.rs could be extended to export the json into a file?
And maybe it could also be extended to parse a directory containing sql-files, and to use an optional parameter for the folder for generated json files?

I never before used Rust. I could try to learn the basics of rust to implement this. But maybe it is much more easy to do for developers experienced in rust then for me, which I am a database specialist, but not a rust developer?

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reading the example cli.rs and clarifying whether the scope is file-based batch processing or MSSQL integration. Define the input and output behavior, including directory handling and matching .sql/.json base names, then verify the chosen workflow can run as a Windows program without Rust installed.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust, sql
Domain
cli, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.