Problem Description

The goal is to take a list of JSON objects as input and insert data into a DuckDB database.

You will complete the implementation from here: https://replit.com/@JayGoel/DuckDB-Go-Insertion#main.go

Acceptance Criteria

• Input: an .ndjson file where each row will have a json object. The JSON will not have any Array or Map structure.
• The function will then do the following:
  • Create a table if it doesn't exist
  • Add whatever columns are necessary as non-nullable string types
  • Use the DuckDB Appender API (https://github.com/marcboeker/go-duckdb#duckdb-appender-api) to upload data
• This should be broken into the following functions: createTable(), addColumns(), insertData(). When first creating the table, just create a single column, __row_id.