Auto increment ID in JavaScript

SELECT * FROM Table ORDER BY ID DESC LIMIT 1

SELECT * FROM Table ORDER BY ID DESC LIMIT 1

await supabase.from('table').select('id').order('id', {ascending: false}).limit(1)

await supabase.from('table').select('id').order('id', {ascending: false}).limit(1)

const lastID = await supabase
    .from('test')
    .select('id')
    .order('id', { ascending: false })
    .limit(1);

const { error } = await supabase
    .from('test')
    .insert({ id: lastID + 1, message: 'test' });

console.log(JSON.stringify(error));

const lastID = await supabase
    .from('test')
    .select('id')
    .order('id', { ascending: false })
    .limit(1);

const { error } = await supabase
    .from('test')
    .insert({ id: lastID + 1, message: 'test' });

console.log(JSON.stringify(error));