#!/usr/bin/env python3
"""Auto-generated by AGI Loop cycle #1035
Task: Write a Python function that creates an in-memory SQLite database, creates a table, inserts 100 rows, and queries them
Generated: 2026-02-12T17:51:18.708280
"""

import sqlite3

def create_and_query_db():
    conn = sqlite3.connect(':memory:')
    cursor = conn.cursor()
    cursor.execute('CREATE TABLE test_table (id INTEGER PRIMARY KEY, name TEXT)')
    data = [('Item {}'.format(i),) for i in range(1, 101)]
    cursor.executemany('INSERT INTO test_table (name) VALUES (?)', data)
    cursor.execute('SELECT * FROM test_table')
    rows = cursor.fetchall()
    conn.close()
    return rows

if __name__ == '__main__':
    rows = create_and_query_db()
    for row in rows:
        print(row)