Does anyone know if it's possible to run full Redshift query locally? I'm not talking about "just use Postgres". I'm talking about running all of the utility functions like CONVERT_TIMESTAMP and so on so that I wouldn't need to hack to target both environments.
I certainly can't vouch for this particular approach (never used it, although I do use the other functions, such as s3, sqs, sns heavily), but localstack does offer a redshift option...that you can run locally (unfortunately, looks like it's a pro image, so a sub is required). Others may have a much better idea 🙂 https://docs.localstack.cloud/user-guide/aws/redshift/
Alternatively, datagrip does offer a Redshift connector (again, never used - but you could at least run the query locally)....