Could not able to use WITH & AS keyword together in .drfit file

[Vedsaga]

Describe the bug

Steps

1. Create a dart class model

import 'package:freezed_annotation/freezed_annotation.dart';

part 'row_meta_data.freezed.dart';

@freezed
class RowMetaData with _$RowMetaData {
  const factory RowMetaData({
    required int id,
    required DateTime updated,
    required DateTime created,
  }) = _RowMetaData;
}

2. Create a drift file

-- import starts
import 'package:main/main.dart';
-- import ends

-- Create profile table
CREATE TABLE IF NOT EXISTS profile (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    dob DATE NOT NULL
) WITH RowMetaData AS ProfileTable;

Actual

// GENERATED CODE - DO NOT MODIFY BY HAND

part of 'app_db.dart';

// ignore_for_file: type=lint
class Profile extends Table with TableInfo<Profile, RowMetaData> {
...
}

Expected

Generated class should have the applied both CustomRow & table name to ProfileTable override.

However it does not as it seems. TableInfo only support two generic annotations, <TableDsl extends Table, D>

mixin TableInfo<TableDsl extends Table, D> on Table implements DatabaseSchemaEntity, ResultSetImplementation<TableDsl, D>

So, only able to use AS or WITH keyword.

[simolus3]

AS controls the name of the row class, so it can't be combined with WITH (which prevents row classes from being generated altogether).

There is no reliable way to control the name of the generated table name at the moment. I'll think about how to do this - perhaps we need an annotation system in drift files as well.

[greenking19]

@simolus3
I am currently facing this issue as well. 🙋
I have a lot of table fields and don't want to write my own Dart Table.
May I use build_runner to translate the drift file into a dart file and then copy it over for use?