Include in relations generating multiple queries instead of one join query

[nivruth-naka]

{
  "where": {
    "and": [
      {
        "effectiveDate": {
          "lte": "2023-03-01"
        }
      },
      {
        "expiryDate": {
          "gte": "2023-03-01"
        }
      }
    ]
  },
  "order": "code asc",
  "include": [
    {
      "relation": "trans"
    }
  ]
}

I am trying to use the above filter in my Loopback project and noticing performance issues. Upon enabling debug logging for the loopback connector I noticed that the include relation is being queried separately sequentially after a separate main query is executed. My understanding from the docs was that it would be a single join query but instead I am seeing 11 queries (1 main query which returns 10 rows and 10 sequential queries for each result from the main query for the include relation part). Is this a bug? This is a one-one association and in my models I am using @hasOne and @belongsTo as well. Please assist.

[shubhamp-sf]

For anyone stopping by here in future, the discussion on this is moved here: #9345