[Info-vax] CRTL and RMS vs SSIO

[Lawrence D’Oliveiro]

On Thursday, October 14, 2021 at 9:34:14 PM UTC+13, Jan-Erik Söderholm wrote:
> Den 2021-10-14 kl. 02:30, skrev Lawrence D’Oliveiro: 
>> On Thursday, October 14, 2021 at 4:10:52 AM UTC+13, Dave Froble wrote: 
>>> Also, I've noticed that doing some things with SQL can be much more complex. 
>> 
>> Only if you have to do them in COBOL! 
>>
> Doesn't really matter what language you use EXEC SQL and END EXEC in, 
> the SQL within that block looks the same.

There are some kinds of SQL you can only realistically do in a dynamic language. For example:

    sort = \
        {
            "id" : "id",
            "name" : "name",
            "when_saved" : "timestamp_ns",
        }.get(opts.get("sort"), "name")
    ...
    for entry in db_iter \
      (
        db,
        "select id, name, description, timestamp_ns from materials order by %s" % sort
      ) \
    :
        ...