Matt Travis

QGIS has a password manager but it look like this doesn't extend to s3/GCS. https://docs.qgis.org/3.40/en/docs/user_manual/auth_system/auth_overview.html A recent update is to the introduction of the Cloud provider in the browser. ...

@marklit thanks for raising, I meant to do this myself. I think this should be a priority add. We could go further than casting to JSON though and elevate all...

@cholmes agreed it makes sense to keep the outputted pq as JSON only. I'll take a look at flattening the flatgeobuf and geopackage outputs.

Just an update to say I'm getting somewhere with this.  ``` # Start building the SELECT query select_query = "SELECT *" # Construct the SELECT clause with array conversion...

I had to cast the JSON as text here because if you don't then QGIS views the JSON as BLOBs 

#73 now includes the ability to cast to JSON the STRUCT fields. Would be good to investigate the possibility of adding a setting to cast the JSON as text so...

@marklit further to this I actually realised last night that QGIS does handle some structs ok but not sources as it's not an JSON object but and array of those....

@marklit I saw this comment in an email. I'm not sure why it didn't get posted on github _It looks like QGIS will break structure fields up into separate fields...

@marklit I just noticed that the issue you submitted was using 3.42.0-Münster? So have you seen the sources field automatically split like names is somewhere?

@marklit Ok, sources is still an issue in `3.42.0`. Hopefully this will be resolved soon. Also, you may want to change `3.4.2` to `3.42.0` in the issue.