Are Local Secondary Indeces and single table design principles deprecated?

[neaumusic]

[neaumusic]

I've been working on my schema and was really happy, but I've found further issues -- amplify mock fetches non-projected attributes, but AppSync queries do not. My current schema:

enum _CONTENT { _CONTENT }

type Content
  @model(timestamps: { createdAt: "LSI1", updatedAt: "updatedAt" })
  @auth(rules: [{ allow: groups, groups: ["Admin"] }]) {
  PK: _CONTENT!
    @primaryKey(sortKeyFields: ["SK"])
    @index(name: "LSI1", sortKeyFields: ["LSI1"], queryField: "contentByLSI1")
    @index(name: "LSI2", sortKeyFields: ["LSI2"], queryField: "contentByLSI2")
    @index(name: "LSI3", sortKeyFields: ["LSI3"], queryField: "contentByLSI3")
    @index(name: "LSI4", sortKeyFields: ["LSI4"], queryField: "contentByLSI4")
    @index(name: "LSI5", sortKeyFields: ["LSI5"], queryField: "contentByLSI5")
  SK: String! # ID
  LSI1: String # createdAt
  LSI2: String
  LSI3: String
  LSI4: String
  LSI5: String

  # Image *LSI2* match Content *PK/SK* fields
  images: [Image]! @hasMany(indexName: "LSI2", fields: ["PK", "SK"])
  updatedAt: AWSDateTime!
  __typename: String!
}

type Image
  @model(timestamps: { createdAt: "LSI1", updatedAt: "updatedAt" })
  @auth(rules: [{ allow: groups, groups: ["Admin"] }]) {
  PK: _CONTENT!
    @primaryKey(sortKeyFields: ["SK"])
    @index(name: "LSI1", sortKeyFields: ["LSI1"], queryField: "imageByLSI1")
    @index(name: "LSI2", sortKeyFields: ["LSI2"], queryField: "imageByLSI2")
    @index(name: "LSI3", sortKeyFields: ["LSI3"], queryField: "imageByLSI3")
    @index(name: "LSI4", sortKeyFields: ["LSI4"], queryField: "imageByLSI4")
    @index(name: "LSI5", sortKeyFields: ["LSI5"], queryField: "imageByLSI5")
  SK: String! # ID
  LSI1: String # createdAt
  LSI2: String # parent ID
  LSI3: String
  LSI4: String
  LSI5: String

  updatedAt: AWSDateTime!
  __typename: String!
}

// cli.json →
...
"secondarykeyasgsi": false,
...

// override.ts →

import { AmplifyApiGraphQlResourceStackTemplate } from '@aws-amplify/cli-extensibility-helper';

export function override(resources: AmplifyApiGraphQlResourceStackTemplate) {
  Object.values(resources.models).forEach(modelDirectiveStack => {
    modelDirectiveStack.modelDDBTable?.addPropertyOverride("LocalSecondaryIndexes.0.Projection.ProjectionType", "KEYS_ONLY");
    modelDirectiveStack.modelDDBTable?.addPropertyOverride("LocalSecondaryIndexes.1.Projection.ProjectionType", "KEYS_ONLY");
    modelDirectiveStack.modelDDBTable?.addPropertyOverride("LocalSecondaryIndexes.2.Projection.ProjectionType", "KEYS_ONLY");
    modelDirectiveStack.modelDDBTable?.addPropertyOverride("LocalSecondaryIndexes.3.Projection.ProjectionType", "KEYS_ONLY");
    modelDirectiveStack.modelDDBTable?.addPropertyOverride("LocalSecondaryIndexes.4.Projection.ProjectionType", "KEYS_ONLY");
  });
}