Column cannot be resolved, Querying Athena through Lambda and boto3

Good afternoon fellow AWS users.

I'm trying to get data from Athena into a Lambda session. I've done this before with another dataset, with no problems, so I know the Python script is correctly querying Athena.

I've recently had to change from one table to another, which is located in a separate database, and now my lambda script is failing.

I'll need to provide some context of how I'm viewing the error in the output logs, so:

import boto3

#get athena clint
client = boto3.client('athena')

#define sql query string
query = f"""
        select "column_1" from table
     """
 
#run query
queryStart = client.start_query_execution(
            QueryString = query,
            QueryExecutionContext = {
                'Database': 'database',
                'Catalog' : 'catalog'
            }
        )

#get current state of execution
queryExecution = client.get_query_execution(QueryExecutionId=queryStart['QueryExecutionId'])

The queryExecution object attribute ["QueryExecution"]["Status"]["State"] is "FAILED", and the attribute ["QueryExecution"]["Status"]["StateChangeReason"] is:

SYNTAX_ERROR: line 1:8: Column 'column_1' cannot be resolved

The query works fine in Athena.

I have permission for all resources, and all actions, on both Lake Formation and Athena.

I've tried putting the column in double quotes, I've tried giving the table an alias, I've tried backticks, checking letter cases, everything.

Also, when I change the query string to

#define sql query string
query = f"""
        select * from table limit 1
     """

The error changes to:

SYNTAX_ERROR: line 1:8: SELECT * not allowed from relation that has no columns

What haven't I tried? Even just a suggestion of where I can start looking for a solution would help; I've literally spent all of today and last night on this.