irissqlcli has a docker version of the tool (even two versions, including for web), is it acceptable?

And demo docker-compose-example.yml, which can be used to test it locally with IRIS

Well, if you require some parts of API to be anonymously available, and another part requires authorization. Then the easiest way is to implement two these APIs separately,  and configure Web Applications this way, where one of them will have anonymous access, and another would require password. And it will work, and you will not need to do anything else.

But if have everything in on API, you can look at my demo project. Based on Realworld application, offereded realizations in many different languages and frameworks.

have a look at the window functions in the documentation 

I would recommend using .editorconfig, it's supported by VSCode. And it's very useful in this thing, when would like to have a control on indention settings in the entire project.

Hi, the way you trying to install is correct. But could you check the version of Python installed there, it requires version from 3.7 to 3.10

Good to know, that now it's available for both platforms by the same name

$ docker manifest inspect containers.intersystems.com/intersystems/iris-community:2022.3.0.606.0                                                                                                                                             
{
   "schemaVersion": 2,
   "mediaType": "application/vnd.docker.distribution.manifest.list.v2+json",
   "manifests": [
      {
         "mediaType": "application/vnd.docker.distribution.manifest.v2+json",
         "size": 1584,
         "digest": "sha256:a9ad0e317042db836f3fb620200a0a269543a03714da475232b1a47ce8ce7839",
         "platform": {
            "architecture": "amd64",
            "os": "linux"
         }
      },
      {
         "mediaType": "application/vnd.docker.distribution.manifest.v2+json",
         "size": 1584,
         "digest": "sha256:80ffdd649c7ad9bc7d94a97538a88b0f11e15961a2ef9ea12715dba5ba2631a6",
         "platform": {
            "architecture": "arm64",
            "os": "linux",
            "variant": "v8"
         }
      }
   ]
}

You can find it on WRC, but you should have access

2022.2 may have this issue

What is the actual problem with it? 

All export import for the code should work the same no matter of OS.

Could you explain a bit more, about what do you you want to achieve?

set ws("A1") = "blah"

is just multilevel variable

if you have object in ws, with field A1, than 

set ws.A1 = "blah"

or 

set $property(ws, "A1") = "blah"

While WinSQL does not offer direct support for InterSystems products, out of the box, and as far as I know, no plugins exist. I would recommend switching to something with better support, e.g. Datagrip or DBeaver.

Or if it's required using WinSQL, you may write a plugin for it or order it (I can help with it), which will offer better support.