Editing sql in a query layer published as a map service

[RowanWinsemius]

Hi there,

I've made a query layer based on some MSSQL Server tables which I've published as a map service. Now I'm wondering if it's possible to edit the sql defining the query layer via the REST API of the map service. I'd like users of a web app to tweak some parameters such as date range, which would in turn edit the sql statement.

Any tips as to whether this is do-able?

Thanks,

Rowan

[JonathanQuinn]

You can probably take advantage of dynamic layers to pass in your own layer definition.