Can you get an image field from a custom record in SuiteQL

I don't think so - at least not yet. Basically, binary data isn't available.