Why does my Direct Database SQL Query only return an array of NULL objects?

When I make a simple query on one of my databases:

SELECT * FROM x2_39

I only get NULL elements back (the right amount). Could it be because I'm using a legacy plan? The strange thing is that when I change the "Return" type from List to Single, it works, but only for one element. Does anyone have any idea?

Thank you.