Support for insert, update and delete queries planned?

[pdecat]

Hi,

is it planned to add support for insert, update and delete queries in the future?

It would be awesome to able to do things like:

DELETE
FROM aws_ec2_instance
WHERE instance_id in
    (SELECT instance_id
     FROM aws_ec2_instance
     WHERE tags->>'Name' = 'Packer Builder'
       AND launch_time < (now() - '1 day'::interval))

and:

UPDATE aws_ebs_snapshot
SET tags = (tags || '{"mgmt": "to delete"}')
WHERE snapshot_id in
    (SELECT snapshot_id
     FROM aws_ebs_snapshot
     WHERE start_time < (now() - '4 weeks'::interval))

PS: I did not find any public roadmap for steampipe, is there one?

[e-gineer]

We agree that support for insert/update/delete could be awesome, and it's definitely possible with the Postgres FDW layer. (There will of course be a lot of interesting edge cases to work through in this area, especially since each change will require different API calls etc - even across columns.)

For now we're tightly focused on querying and reporting and making that as robust and awesome as we can. We find that most users are focused on getting data out of the system initially and build trust there.

We don't have a public roadmap at this point, but really love hearing ideas for how to improve Steampipe! There is more active discussion in our Slack community.

Very open to PRs too - let us know if there is anything you'd like to work on!