How do I specify columns orders when loading form an array of JSON objects?

[tddschn]

Is your feature request related to a problem? Please describe.

A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

I'm loading from a JSON file with an array of objects with keys b, a and the generated sqlite database will have column a before b. I know the key value pairs in a JSON object is unordered, so I am wondering if I can specify the order of columns in the output database.

Describe the solution you'd like

A clear and concise description of what you want to happen.

Maybe add a command line arg like this: --column-order b,a.

Describe alternatives you've considered

A clear and concise description of any alternative solutions or features you've considered.

Additional context

Add any other context or screenshots about the feature request here.

[thombashi]

@tddschn I couldn't quite figure out the situation where the columns needed to be reordered. You can specify a query like SELECT b, a FROM xxx. Does this not work for you?" If so, could you describe your situation in more detail?

[github-actions[bot]]

This issue is stale because it has been open 15 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 7 days with no activity.