Sample

import collections
import sqlite3
import timeit
import os
import itertools

ColsCount = 100

def createTable(conn, rows=100000, cols=ColsCount):
    c = conn.cursor()
    columns = ",".join("Col{0} text".format(x) for x in xrange(cols))
    values = ",".join("\"Value_{0}\"".format(x) for x in xrange(cols))
    c.execute("CREATE TABLE test (id int, {0} )".format(columns))
    for x in xrange(rows):
        c.execute("INSERT INTO test VALUES ({0}, {1})".format(x, values))
    conn.commit()

Columns = tuple(itertools.chain(('Id',), tuple("Col{0}".format(x) for x in xrange(ColsCount))))
TupleClass = collections.namedtuple("TupleClass", Columns)

class RowWrapper(object):
    def __init__(self, values):
        self.Id = values[0]
        for x in xrange(ColsCount):
            setattr(self, "Col{0}".format(x), values[x + 1])

class Tester:
    query = "SELECT * FROM test"

    def __init__(self, conn):
        self.cursor = conn.cursor()

    def test1(self):
        return tuple(row for row in self.cursor.execute(self.query))

    def test2(self):
        return tuple(RowWrapper(row) for row in self.cursor.execute(self.query))

    def test3(self):
        return tuple(TupleClass._make(row) for row in self.cursor.execute(self.query))

if __name__ == '__main__':
    fileName = 'example.db'
    filePath = os.path.join(os.path.dirname(os.path.realpath(__file__)), fileName)
    print(filePath)
    try:
        os.remove(filePath)
    except OSError:
        pass
    conn = sqlite3.connect(filePath)
    createTable(conn)
    tester = Tester(conn)
    t1 = timeit.Timer(tester.test1)
    t2 = timeit.Timer(tester.test2)
    t3 = timeit.Timer(tester.test3)
    print("Sample 1: {0}".format(t1.timeit(1)))
    print("Sample 2: {0}".format(t2.timeit(1)))
    print("Sample 3: {0}".format(t3.timeit(1)))