@jeffreyaven thanks for responding, I am trying to do a join with another table. So I am able to join using 'csv' as in below code. But want to check if I can do the same with 'dict'.

The below join doesn't happen with 'dict'

a.name = b.virtualMachineScaleSetName

stackql = StackQL(output='csv')
query = """
select  c.properties
from
  azure.compute.virtual_machine_scale_sets a
  inner join  azure.compute.virtual_machine_scale_set_vms b
    on a.name = b.virtualMachineScaleSetName
  left outer join  azure.compute.virtual_machines c
    on b.name = c.name
where subscriptionId = '%s'
and resourceGroupName = '%s'
;""" % (subscription_id,rg)
res = stackql.execute(query)
print(res)

@jeffreyaven when I run the same sql with 'dict', I don't see anything in the result set. But when I use 'csv'. I can see the properties of all the vms.

thats strange... properties should be an object as well, I may need to try an reproduce, can you tell me what version of pystackql and stackql you are running, you can get this using stackql.package_version and stackql.version respectively

@jeffreyaven , it works as you said, I must have overlooked something. So output='dict' or 'csv' is just to format the result set and not the internal representation of data, is it.

Correct @vwake7 , output is simply the format