FAILED tests/test_extracts.py::test_extracts[True-kwargs0-Species] - AssertionError: assert [Index(seq=0,...ns=['value'])] == []
FAILED tests/test_extracts.py::test_extracts[True-kwargs1-species_id] - AssertionError: assert [Index(seq=0,...ns=['value'])] == []
FAILED tests/test_extracts.py::test_extracts[True-kwargs2-species_id] - AssertionError: assert [Index(seq=0,...ns=['value'])] == []
FAILED tests/test_extracts.py::test_extracts[False-kwargs0-Species] - AssertionError: assert [Index(seq=0,...ns=['value'])] == []
FAILED tests/test_extracts.py::test_extracts[False-kwargs1-species_id] - AssertionError: assert [Index(seq=0,...ns=['value'])] == []
FAILED tests/test_extracts.py::test_extracts[False-kwargs2-species_id] - AssertionError: assert [Index(seq=0,...ns=['value'])] == []
FAILED tests/test_lookup.py::test_lookup_with_extra_insert_parameters - AssertionError: assert {'convert_to_...0-01-01', ...} == {'convert_to_...0-01-01', ...}

self = <Database <sqlite3.Connection object at 0x7f4822e46a80>>
sql = 'UPDATE [table] AS m SET [a] = v.[a], [b] = v.[b], [c] = v.[c] FROM (VALUES (?, ?, ?, ?)) AS v(custom_id, a, b, c) WHERE m.[custom_id] = v.[custom_id]'
parameters = ['4acc71e0547112eb432f0a36fb1924c4a738cb49', 1, 2, 3]

    def execute(
        self, sql: str, parameters: Optional[Union[Iterable, dict]] = None
    ) -> sqlite3.Cursor:
        """
        Execute SQL query and return a ``sqlite3.Cursor``.
    
        :param sql: SQL query to execute
        :param parameters: Parameters to use in that query - an iterable for ``where id = ?``
          parameters, or a dictionary for ``where id = :id``
        """
        if self._tracer:
            self._tracer(sql, parameters)
        if parameters is not None:
>           return self.conn.execute(sql, parameters)
E           sqlite3.OperationalError: near "AS": syntax error

FAILED tests/test_conversions.py::test_upsert_conversion - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_conversions.py::test_upsert_all_conversion - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_create.py::test_create_table_with_custom_columns[upsert] - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_create.py::test_create_table_with_custom_columns[upsert_all] - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_create.py::test_insert_all_analyze[upsert_all] - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_upsert.py::test_upsert - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_upsert.py::test_upsert_all - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_upsert.py::test_upsert_all_not_null - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_upsert.py::test_upsert_with_hash_id - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_upsert.py::test_upsert_with_hash_id_columns[None] - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_upsert.py::test_upsert_with_hash_id_columns[custom_id] - sqlite3.OperationalError: near "AS": syntax error
FAILED tests/test_upsert.py::test_upsert_compound_primary_key - sqlite3.OperationalError: near "AS": syntax error

FAILED tests/test_create.py::test_create_table_with_custom_columns[False-upsert] - AssertionError: assert ['dogs'] == ['dogs', 't2c...22ab3c51f194']
  
  Right contains one more item: 't2ca612dba8569c9fc12922ab3c51f194'
  
  Full diff:
    [
        'dogs',
  -     't2ca612dba8569c9fc12922ab3c51f194',
    ]

    def test_upsert_alter(db_path, tmpdir):
        json_path = str(tmpdir / "dogs.json")
        db = Database(db_path)
        insert_dogs = [{"id": 1, "name": "Cleo"}]
        write_json(json_path, insert_dogs)
        result = CliRunner().invoke(
            cli.cli, ["insert", db_path, "dogs", json_path, "--pk", "id"]
        )
        assert result.exit_code == 0, result.output
        # Should fail with error code if no --alter
        upsert_dogs = [{"id": 1, "age": 5}]
        write_json(json_path, upsert_dogs)
        result = CliRunner().invoke(
            cli.cli, ["upsert", db_path, "dogs", json_path, "--pk", "id"]
        )
        assert result.exit_code == 1
>       assert (
            "Error: table dogs has no column named age\n\n"
            "Try using --alter to add additional columns"
        ) == result.output.strip()
E       AssertionError: assert 'Error: table...ional columns' == 'Error: no su...ters = [5, 1]'
E         
E         - Error: no such column: age
E         + Error: table dogs has no column named age
E           
E         + Try using --alter to add additional columns
E         - sql = UPDATE [dogs] SET [age] = ? WHERE [id] = ?
E         - parameters = [5, 1]