Raw SQL Query Not Working

[Will-Cooper]

The raw_query function seems to be returning empty tables, even with things which should be populated, e.g:

select * from Sources

but Photometry has returned data...
c.f. Ricky email:

So If I wanted to get young objects from Simple what would I have to use as a query, assuming I would have to go to https://www.simple-bd-archive.org/raw_query I thought this would work " select * from Sources join Gravities using (source) " but it returns nothing even with a where source like "%twa%" ...

[Will-Cooper]

raise ValueError("Duplicate column names")
    ValueError: Duplicate column names

[Will-Cooper]

Note using s.source=p.source raises a TypeError("quote_from_bytes() expected bytes") when it starts trying to parse some columns.
It is just the joins which are not returning anything on the website.

[Will-Cooper]

@dr-rodriguez any thoughts on why we see joins not work on the server (anymore at least, I'm sure they used to), but they do work locally?

[kelle]

Another example of a raw SQL query not working on the website: SIMPLE-AstroDB/SIMPLE-db#647