Allow use .sql files like .drift

[listepo]

I working on tool for drift and it export sql schema

[simolus3]

Could you share more details on what kind of enhancement you'd like to see?

Is this similar / a duplicate of #3057?

[listepo]

@simolus3 Not really, we're talking about the possibility of doing migrations with native .sql files like .drift now

like

import 'package:drift/drift.dart'
import 'package:drift/native.dart'

part 'database.g.dart';

@DriftDatabase(include: {'tables.sql'})
class MyDb extends _$MyDb {
  // This example creates a simple in-memory database (without actual
  // persistence).
  // To store data, see the database setups from other "Getting started" guides.
  MyDb() : super([NativeDatabase](https://pub.dev/documentation/drift/latest/native/NativeDatabase-class.html).[memory](https://pub.dev/documentation/drift/latest/native/NativeDatabase/NativeDatabase.memory.html)());

  @override
  int get schemaVersion => 1;
}

[listepo]

or something similar

import 'package:drift/drift.dart';
import 'package:drift/native.dart''

part 'database.g.dart';

@DriftDatabase(include: 'assets/migrations/*.sql')
class MyDb extends _$MyDb {
  // This example creates a simple in-memory database (without actual
  // persistence).
  // To store data, see the database setups from other "Getting started" guides.
  MyDb() : super([NativeDatabase](https://pub.dev/documentation/drift/latest/native/NativeDatabase-class.html).[memory](https://pub.dev/documentation/drift/latest/native/NativeDatabase/NativeDatabase.memory.html)());

  @override
  int get schemaVersion => 1;
}

include: 'assets/migrations/*.sql'